Microsoft KB Archive/928720

= An access violation occurs when you try to open an Excel 2007 workbook file that resides on a SharePoint Server 2007 server =

Article ID: 928720

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office Excel 2007

-



SYMPTOMS
You use Microsoft Office Excel 2007 Web Access to try to open an Excel 2007 workbook file (.xlsb). This workbook file resides on a Microsoft Office SharePoint Server 2007 server that is running Excel Services. When you do this, an access violation occurs.

Additionally, you receive an error message that resembles the following error message:

xlsrv!TGS::SetPessheetY+0x3b [ \office\source\xlshared\src\calc\fnmatrix.cpp @ 1669]



CAUSE
This problem occurs when you save an Excel workbook file for which the following conditions are true:
 * The file includes a TREND function that uses a calculation.
 * The file was saved to a document library on a SharePoint Server 2007 server that is running Excel Services.

For example, a TREND function that includes a calculation may resemble the following function:

=TREND 

In this case, when you try to open the workbook file by using Excel Web Access, an access violation occurs.

Note This problem does not occur when you open a workbook file that contains a TREND function that uses a calculation on a computer that is running Excel 2007.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Additional query words: XL2007 Excel2007 MOSS2007 XLServices ExcelServices ECS EWR

Keywords: kbtshoot kbprb kbexpertiseinter KB928720

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.