Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Error message when you try to view an Excel 2007 workbook that contains a formula that uses a caret operator in Excel Services: "The workbook may be in an unsupported file format, or it may be corrupt"


View products that this article applies to.

Symptoms

Consider the following scenario. You create a workbook in Microsoft Office Excel 2007, and then you save the workbook in Excel workbook format (.xlsx). One or more cells in the workbook contain a formula that uses the caret (^) operator to mean exponentiation. For example, the workbook contains the following:
CellValue
E55
F5=E5 ^2
You publish the workbook to Excel Services, a feature of Microsoft Office SharePoint Server 2007. In this scenario, Excel Services does not load the workbook when you use a Web browser to try to view the workbook that you published to the server. Instead, you receive the following error message:
Unable to Load Workbook

The workbook that you selected cannot be opened.
The workbook may be in an unsupported file format, or it may be corrupt.
Would you like to try and open this file in Excel?

↑ Back to the top


Cause

This issue occurs if a space character is in front of the caret operator in the formula.

↑ Back to the top


Workaround

To work around this issue, use one of the following procedures:
  • Remove the space character that is in front of the caret operator in the formula.
  • Save the workbook in the non-XML binary workbook format (.xlsb). Then, publish the workbook to the server.

↑ Back to the top


More information

For more information about Excel Services, visit the following Microsoft Web sites:

↑ Back to the top


Keywords: KB928719, kbexpertiseinter, kbprb, kbtshoot, kberrmsg

↑ Back to the top

Article Info
Article ID : 928719
Revision : 2
Created on : 10/17/2007
Published on : 10/17/2007
Exists online : False
Views : 397