Tips for choosing file formats
in Excel 2007+
Caution
- All Systems2win Excel templates require macros to be enabled
- You cannot choose the xlsx format (which strips all macros)
so you must either manually choose a different file format each time that you save a document,
or change your default file format
How to change your default file format As delivered from Microsoft, the default file format is .xlsx To change the default file format on your computer, |
Compatibility
Systems2win templates are delivered in .xls format -
which is compatible with Office 97 through 2003 - as well as 2007+.
Some advanced features are not fully supported by very old versions of Excel 97 or 2000. See Known Issues.
If different people in your work team use various versions of Microsoft Office
- then you will probably want to leave your working documents in Office 97-2003 Compatibility mode. (.xls)
Tip: The Compatibility Checker dialog often comes up with warnings that there will be "Significant Loss of Functionality" if you save your file in .xls Excel 97-2003 compatibility format. Most of these warnings are simply dead wrong. It itemizes the functionality that might be lost, so you can test it for yourself, but you will find that there is usually no loss of functionality. Many Systems2win customers routinely save all of their Excel files in .xls 97-2003 compatibility format - and and everything works just fine.
If everyone on your work team uses Office 2007+
- then you might choose to convert your working documents into one of the the new Office 2007+ formats - which both retain macros, with slightly improved performance, but compromised backward compatibility:
- .xlsm, or...
- .xlsb, (which has even more improved performance, and even greater compromised backward compatibility)
To automatically convert a file
- Simply select File > Convert.
This will automatically convert your file to .xlsm if there are macros.
