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


The information in this article applies to:

  • Microsoft Office Excel 2003
  • Microsoft Excel 2002
  • Microsoft Excel 2000
  • Microsoft Excel 97 for Windows
  • Microsoft SharePoint Portal Server 2001

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.
Modification Type:MajorLast Reviewed:12/10/2003
Keywords:kberrmsg kbprb KB831929 kbAudEndUser
©2003 Microsoft Corporation. All rights reserved.