"Cannot open PivotTable source file... " error message when you open an Excel workbook

Article translations Article translations
Article ID: 831929 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

When you open a Microsoft Excel workbook that is located in a Web folder that is located on a computer that is running Microsoft SharePoint Portal Server 2001, you may receive the following error message:
Cannot open PivotTable source file '[filename(x.y).xls]SourceData'
Note In the error message, x.y is the version of the document in the Shadow folder that represents the current version of the checked out document.

CAUSE

This behavior may occur if you double-click the Excel workbook that is located in the Web folder after the workbook has been checked out. This behavior does not occur if you open the file through the Excel interface or through the SharePoint Portal Web site's document library.

WORKAROUND

To work around this behavior, open the Excel workbook that is located in the Web folder directly in Excel (on the File menu, click Open). Alternatively, you may open it through the SharePoint Portal Web site.

Properties

Article ID: 831929 - Last Review: December 10, 2003 - Revision: 1.2
APPLIES TO
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft SharePoint Portal Server 2001
Keywords: 
kberrmsg kbprb KB831929

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com