Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 928719 - Last Review: October 17, 2007 - Revision: 2.0
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"
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:
Collapse this tableExpand this table
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?
This issue occurs if a space character is in front of the caret operator in the formula.
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.
For more information about Excel Services, visit the following Microsoft Web sites:
APPLIES TO
- Microsoft Office Excel 2007
- Microsoft Office SharePoint Server 2007
- Excel Services
| kberrmsg kbtshoot kbprb kbexpertiseinter KB928719 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate