The Computer Oracle

How do I prevent Excel from asking if I'm sure I want to save in ODS format each time?

--------------------------------------------------
Rise to the top 3% as a developer or hire one of them at Toptal: https://topt.al/25cXVn
--------------------------------------------------

Track title: CC D Schuberts Piano Sonata D 850 in D

--

Chapters
00:00 How Do I Prevent Excel From Asking If I'M Sure I Want To Save In Ods Format Each Time?
00:28 Accepted Answer Score 13
01:01 Answer 2 Score 2
01:18 Thank you

--

Full question
https://superuser.com/questions/1386710/...

--

Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...

--

Tags
#windows #microsoftexcel

#avk47



ACCEPTED ANSWER

Score 13


To suppress the warning message:

  • Start regedit

  • Navigate to the following location (substitute 16 with your Office version number):

    HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options
    
  • Right-click on the right and select New > DWORD

  • Rename as DisableSaveAsLossWarningOpenDocumentSpreadsheet

  • Double-click it and set its value to 1




ANSWER 2

Score 2


This would be the .reg file to apply the change:

Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options]
"DisableSaveAsLossWarningOpenDocumentSpreadsheet"=dword:00000001

Sorry for the trivial post, but I'm lazy :-)