Friday, October 12, 2012

Hmm, so you CAN validate an Excel files compatibility with SharePoint 2010

Well, I stand corrected.  In my previous post on Excel Data Validation as an unsupported feature in SharePoint and the perils of hidden worksheets, I may have griped a little and said
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:

- Data validation

Would you like to try and open this file in Excel?
Well, I stand corrected!

 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