Friday, August 21, 2009

Excel Services Compatibility Checker

A while back I had a customer who wished to use Excel Services to do some project reporting dashboards. After initially uploading the Excel file and configuring Excel Services accordingly I tried opening it with the Excel Web Access web part. The follow error appeared on the screen.

This and many other things within Excel that can cause similar errors including adding images or query tables. If you are using one excel sheet to populate several dashboard it can extremely frustrating when a simple change to your Excel file causes them all to display an error screen.

After searching around for a while I came upon the Excel Services Compatibility Checker. This tool is available as a download and it allows you to determine what items within your Excel file will cause Excel Services to error out before you upload the file. Thus avoiding the annoyance of all your dashboards breaking because someone though it would be cool to add an image to the file.


Click here for the Excel Services Compatibility Checker download page.
Click here for information on the most recent build of the tool.

No comments: