Article ID: 184900 - Last Review: September 22, 2005 - Revision: 1.1

XL97: Errors Activating Embedded Object Containing PivotTable

Retired KB ArticleRetired KB Content Disclaimer
View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
This article was previously published under Q184900
Expand all | Collapse all

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.
Back to the top

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.
Back to the top

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:
151261  (http://support.microsoft.com/kb/151261/EN-US/ ) OFF97: How to Obtain and Install MS Office 97 SR-2
Back to the top

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).
Back to the top
APPLIES TO
  • Microsoft Excel 97 Standard Edition
Back to the top
Keywords: 
kbhotfixserver kbqfe kbbug kbfix KB184900
Back to the top
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Back to the top