Question – Sometimes, I may require to work in different Office Suites and to maintain compatibility, I use Open Document Format. But whenever, I save in Open Document Format (ODS – OpenDocument Spreadsheet), I get the Excel warning like below. I don't need this. What is the way out?
Answer – This requires a registry hack, hence you need to take the backup of your registry first. Also, if you are not comfortable with modifying your registry, don't proceed.
For backing up your registry and restoring in case of any issue – https://support.microsoft.com/en-us/kb/322756
1. Press Windows +R, type regedit and press Enter.
2. Navigate to the following location:
HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options
(In case of Excel 2013, replace 16.0 with 15.0, Excel 2010 – 14.0, Excel 2007 – 12.0, Office 2003 – 11.0)
3. Right click on the in the left panel and select New>DWORD.
4. Once new DWORD is create right click on it and select Rename asDisableSaveAsLossWarningOpenDocumentSpreadsheet
5. Set Value data 1 to suppress the warning message.