Odd Workbook Behavior After Modification by MS Access (157495)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
- Microsoft Access 97
- Microsoft Access for Windows 95 7.0
This article was previously published under Q157495 SYMPTOMS
When you open a workbook in Microsoft Excel, cells within the workbook may
display different values, depending on the version of Microsoft Excel you
are currently using.
For example, if you open Book1.xls in Microsoft Excel version 5.0 or 7.0,
cell A1 of Sheet1 may contain the value 100. If you open the same workbook in Microsoft Excel 97, cell A1 of
Sheet1 may contain the value 1.
CAUSE
This may occur if the following conditions are true:
- You have modified the workbook using Microsoft Access by creating a
table linked to a worksheet in the workbook.
-and-
- The workbook in question was saved in the "Microsoft Excel 97 & 5.0/95
Workbook" format by Microsoft Excel 97.
RESOLUTION
If you need to create a table in Microsoft Access that links to a
worksheet in a Microsoft Excel workbook, do not save the workbook in the
"Microsoft Excel 97 & 5.0/95 Workbook" format.
Instead, in Microsoft Excel 97, save your workbook in either of the
following formats.
Save Your Workbook in this ...if Using this Version of
Format... Microsoft Access
-------------------------------------------------------------------
Microsoft Excel Workbook Microsoft Access 97
Microsoft Excel 5.0/95 Workbook Microsoft Access for Windows 95
Saving the workbook in either of these formats will prevent the problem
from occurring.
STATUS
This behavior occurs because the "Microsoft Excel 97 & 5.0/95 Workbook"
file format is not fully supported by Microsoft Access versions 7.0 and
97. This problem no longer occurs in Microsoft Excel 2000.
Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
---|
Keywords: | kbprb KB157495 |
---|
|