Whenever you save a workbook in the future, it will be saved in Compatibility Mode once you change this setting. Change the Save files in this format box to Excel 97-2003.
Change the Save as type to Excel 97-2003 workbookįigure 56- Set Compatibility Mode as the default setting.Navigate to the folder where you wish to save the workbook.To save in Compatibility Modeįigure 55- Change the Save as type to save in Compatibility Mode When you have a file that has been saved in compatibility mode it will tell you at the top of the screen. Compatibility Modeįigure 54-Look for Compatability Mode at the top of the screen Read our tips for saving documents in compatibility mode here. Alternatively, you can save workbooks individually if you know you need to send them to someone with the older version. You can set your workbooks to be saved in this mode all the time, however be aware that you will lose functionality. In later versions, new features keep being added so it becomes necessary to save the workbook in a 2003 friendly way. Specifically, if you are working with someone who is still using Office 2003 then you will have issues because the file format changed with Office 2007 which is the release that followed 2003. When newer versions of Office programs come out, there is new functionality which is not available in the older versions.
0 kommentar(er)
