Make Excel 2007 Always Save in Excel 2003 Format
After the tenth time saving an Excel spreadsheet and then emailing it to a co-worker still using Office 2003, I'm willing to save in 2003 format by default. It's not like the rest of the office is going to switch for a very long time anyway, and this way I can stop sending them the wrong documents by mistake!
Start by clicking that big round Office Button in the upper left hand corner.
In the resulting menu, click the Excel Options button.
Now click the Save tab, and then change the "Safe files in this format" dropdown to "Excel 97-2003 Workbook".
Finally! Now I can't accidentally send files in the wrong format anymore. Was really starting to irritate me.
Disclaimer: Many of our articles require making changes to your system. While we fully test and stand by our advice, there is still the potential for problems when making any configuration changes. Please be careful.
