bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Files > File Format Not Valid

File Format Not Valid

Summary: Sometimes Excel can give some very cryptic errors. Such is the case with Bob, who ran into two “File Format is not Valid” errors. This tip discusses what could be a possible cause of the errors and how to fix them. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Bob works with both Excel 2000 and Excel 2003 on two different computers, and often transfers files between the two. Recently, he began encountering two messages indicating some sort of error. The first is "33430000: File Format is not Valid" and it is immediately followed by "55430000: File Format is not Valid." The files do save and do calculate correctly, but the error messages are (of course) bothersome.

The only information that we've been able to track down that may have a bearing on this problem indicates that the errors may not be due to the workbooks, but to a problem with Excel itself. The problem seems to be related to Windows Registry conflicts between the current version of Excel and the version previously installed on the system.

Information from Microsoft indicates that this problem could crop up with some (but not all) workbooks used on the problem system. You can find a fuller description of the problem, along with a way to modify the Registry to try to fix it, at this page in the Knowledge Base:

http://support.microsoft.com/?kbid=327764

Tip #3166 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007


PivotTables Got You Perplexed? Learn the ins and outs of this powerful data-crunching tool. ExcelTips: PivotTables for the Faint of Heart makes it easy.

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

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

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)