Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Recording a Macro

Adding a Little Animation to Your Life

Converting a Range of URLs to Hyperlinks

Making the Formula Bar Persistent

Engineering Calculations

Digital Signatures for Macros

Fixing the Decimal Point

 

Problems Saving in Older File Format

Summary: Saving files in an older Excel format may cause a few problems that need troubleshooting with this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Subscriber Mike Newton wrote about a problem he was having with a workbook he saved for his client. Mike uses Excel 2000, but his client uses Excel 97 and wanted the workbook in that format. When Mike tried to open the file back on his system, he got errors related to macros.

The first thing to remember both Excel 97 and Excel 2000 use the same file format. Thus, the same file should be able to be loaded under both versions, without the need to do any conversion. This important fact is easy to miss, particularly if you drop-down the Save As Type list in the Save As dialog box and see a format called Microsoft Excel 97-Excel 2000 & 5.0/95 Workbook. You don't use this format to save something for Excel 97; you use it to create two files from the current workbook--one that works in Excel 97/2000 and the other that works in Excel 5.0/95.

This, of course, doesn't explain why Mike had problems opening the workbook back up in his version of Excel. Since it cannot be related to the workbook format, the answer must lie in something that happened to the workbook while it was on the client's Excel 97 system. The causes could be legion, but it is possible that the workbook became infected with a macro virus, or the workbook was corrupted because of some problem with the client's system. (The fact that Mike can't save the file on his system would indicate this latter possibility.)

To check if it was the client's system, take the file you gave to them (before they worked with it) and open it on a different Excel 97 system. If it works with no problem, and you are able to load it back into your Excel 2000 system, then you know the problem is with the client's computer.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2500) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

PivotTables Got You Perplexed? PivotTables for the Faint of Heart shows how you can start using Excel's PivotTable tool right away to spin your data into gold! You discover how easy it really is to crunch the numbers you need to crunch. Uncover the power of creating PivotTables, editing them, formatting them, customizing them, and much more.
 
Check out PivotTables for the Faint of Heart today!