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.

image

In the resulting menu, click the Excel Options button.

image

Now click the Save tab, and then change the “Safe files in this format” dropdown to “Excel 97-2003 Workbook”.

image 

Finally! Now I can’t accidentally send files in the wrong format anymore. Was really starting to irritate me.

Lowell Heddings, better known online as the How-To Geek, spends all his free time bringing you fresh geekery on a daily basis. You can follow him on if you'd like.