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
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 :-)