
Tips.Net > ExcelTips Home > Files > 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.
If you have tons of data to analyze, one of the best tools in Excel's arsenal is the PivotTable. Learn how to use this tool to analyze your data. (more information...)
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
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