XL97: Errors Activating Embedded Object Containing PivotTable

ID: Q184900

The information in this article applies to:

• 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:

   ARTICLE-ID: Q151261
   TITLE : 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:97
Platform          : WINDOWS
Issue type        : kbbug
Solution Type     : kbfix

Last Reviewed: March 24, 1999