So I moved one of our report's into SharePoint, which I received the following error (side note.. wouldn't it be great to validate the file before publishing it Microsoft?)The workbook cannot be opened because it contains the following features that are not supported by Excel in the browser:Well, I stand corrected!
- Data validation
Would you like to try and open this file in Excel?
Clicking the File Menu in Excel (2007\2010), Under the Info tab, you have the option to "Check for Issues".
Once clicked, you can choose to "Inspect" your document, where all the bad stuff that SharePoint yells at you for can be stripped out.
Side note: It's shocking how often sensitive\personal information is attached to your documents. You should use this feature in all Office document types to scrub your files before you start sending them around.
No comments:
Post a Comment