XL97: Error Message: Invalid Data Format (193650)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q193650 SYMPTOMS
When you open a workbook in Microsoft Excel 97 for Windows,
the following error message may appear twice:
Invalid data format
If you try to activate, remove, or export a module in the Visual Basic
Editor, or when you close the workbook, you may receive the same error
message.
CAUSE
This problem occurs if the workbook contains a Visual Basic module named
"dir" or "Dir."
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."
STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 97 for
Windows.
| Modification Type: | Major | Last Reviewed: | 10/22/2000 |
|---|
| Keywords: | kbbug KB193650 |
|---|
|