One of the annoyances that I have come across in my short time working with Excel Services is the cycle of; change workbook -> publish to share point -> make sure everything works -> repeat. Today I happened to find a compatibility checker that works extremely well, especially considering that it is in (probably permanent) beta.
I don't think that I can do a better job explaining how to use it than the author, so just go check out the site! If you just want to download the installation file, you can get it here.
Issues that the compatiblity checker knows how to find/fix
The following is a list of the issues that can be found:
AutoFix available (all of these will be removed from the workbook when auto-fixed):
- Comments
- DialogSheets
- Display Formulas
- Macro Sheet
- OleObjects
- Query Tables
- Shapes
- Validation
- XML Maps
AutoFix sometimes available (will be removed if possible):
- IRM - AutoFix will work if there's no password.
- Protection - AutoFix will work if there's no password.
- VBA - AutoFix will work if the trust-cente enables Automation to interact with the VBA project.
AutoFix will not work for these:
- Unsupported formulas such as External Workbooks and RTD()
- FileFormatResult
excerpt from http://blogs.msdn.com/cumgranosalis