No message when opening Workbook file in Excel web app browser that contains a circular reference


Consider the following scenario:
You have a SharePoint 2010 document library. You have Office Web Apps 2010 installed. On a SharePoint 2010 document library that contains Excel workbooks, the user can choose to 'edit in browser' or 'view in browser'. You open an Excel workbook that contains a circular reference, you are presented with no warning of a circular reference. There is no error message or warning of the file containing a circular reference. 

This feature warning is only available in the Excel full client. When you open the file from the Excel web app into the Excel client, the circular reference warning will appear. The circular reference warning is not available in Excel Web Apps of Office web apps 2010 on a SharePoint Server or Foundation platform. For advanced error handling, utilize the Excel full client.

More Information

Differences between using a workbook in the browser and in Excel

How to remove or allow a circular reference (for Microsoft Office Excel 2007)


Article ID: 2295316 - Last Review: Jul 24, 2012 - Revision: 1