Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL2000: Error Message: Invalid Data Format


View products that this article applies to.

This article was previously published under Q211596

↑ Back to the top


Symptoms

When you open a workbook in Microsoft Excel 2000, the following error message may appear twice:
Invalid data format
If you try to start the Visual Basic Editor, run macros, modify text in a module, remove a module, or export a module in the Visual Basic Editor, or you close the workbook, you may receive the same error message.

↑ Back to the top


Cause

This problem occurs if the workbook contains a Visual Basic module named "dir" or "Dir."

↑ Back to the top


Resolution

If this problem occurs, it is not possible to remove the module from the workbook. It is also not possible to rename the module so that it can be removed or activated.

Because you cannot do anything to the module, you must copy all information from the workbook into a new workbook, save the new workbook with a different name, and then delete the original workbook.

To prevent this problem from occurring, do not name a Visual Basic module "dir" or "Dir."

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top


More information

For additional information about recovering data, click the article number below to view the article in the Microsoft Knowledge Base:
179871� XL2000: Methods for Recovering Data from Damaged Workbooks

↑ Back to the top


Keywords: KB211596, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 211596
Revision : 5
Created on : 11/5/2003
Published on : 11/5/2003
Exists online : False
Views : 304