XL97: Errors Activating Embedded Object Containing PivotTable

• Microsoft Excel 97 for Windows

SYMPTOMS

When you try to double-click or update a Microsoft Excel worksheet object that is contained in a file that was created in another program, such as Microsoft Word, you may receive the following error messages:

Unable to obtain PivotTable data from disk.

-and-

Memory was used up attempting to convert and save. PivotTables(s) will be refreshed upon the first update.

-and-

Cannot be accessed. The file may be read-only, or you may be trying to access a read-only location. Or the server the document is stored on may not be responding.

CAUSE

This problem occurs if the following conditions are true:

• The Excel worksheet contains a PivotTable.


-and-


• You have created the Excel worksheet in an earlier version of Excel.


-and-


• You are opening the embedded Excel object in Excel 97.

RESOLUTION

To correct this problem, obtain Microsoft Word 97 Service Release 2 (SR- 2).

For additional information about SR-2, please see the following article in the Microsoft Knowledge Base:

Q151261 OFF97: How to Obtain and Install MS Office 97 SR-2

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 97 for Windows. This problem was corrected in Microsoft Office 97 Service Release 2 (SR-2).

Additional query words:

Keywords : kbdta
Version : WINDOWS:
Platform : WINDOWS
Issue type : kbbug