Categories
Excel Training

Excel 2010: Saving In The Old 2003 Format

Whilst everyone is changing from the old 2003 version of Excel to the new 2010 version, some people will still need to provide spreadsheets in the older version. If this is for a single or occasional file, in the Save As dialog box simply change the File Type in the bottom box to Excel 97-2000 Workbook, beneath the File Name.

Save In Old StyleIf you are saving in the old format on a regular basis, it will be simpler to change the default file format. Click on the File tab and select Options, and on the Save page, change the default File Type at the top. When everyone is converted, change this back to Excel Workbook.

Default Saving screen

By Richard Bailey

I love what I do; I get to work with an outstanding team to help hundreds of people with their challenges. I’ve learnt a lot from the teams I’ve worked with, no matter the size or industry we all have challenges to overcome, difficult customers, creating a budget or keeping a project on track.