Excel Web Services Compatibility Checker – Automatically fix common errrors

By peter.stilgoe









Excel Web Services Compatibility Checker is a great tool for when you’re trying to publishing Excel dashboards to Sharepoint and you keep getting various web services errors. This tool will check your workbook for compatability errors & also will autofix most errors if you choose.

Typical error message:

“The workbook that you selected cannot be loaded because it contains the following features that are not supported by Excel Services:

External references (links to other workbooks)
Comments, ActiveX controls, Shapes, Text Boxes, Pictures, WordArt, Clip Art, Embedded OLE objects, Ink Annotations, Forms Toolbar controls, Control Toolbox controls, Charts that are part of a group, Signature Lines, or Camera objects

Contact the workbook author.”

Download Excel Web Services Compatibility Checker




Share

Leggi tutto

Import Excel 2007 Spreadsheet as Sharepoint List Error Method ‘post’ of object ‘IOWSPostData’ failed

By peter.stilgoe









If you get the following error Method ‘post’ of object ‘IOWSPostData’ failed, you can fix it by doing the below:

Do a search on you C: drive for a file named: EXPTOOWS.XLA

Open it and Enable Macros

Select the Developer tab and the Visual Bacis or press ALT+11. Same result. You are ready to alter the file.

Search for:

lVer = Application.SharePointVersion(URL)

Add a new line just below:

lVer = 2

Save and exit.

Now try the import again & it should work.

NOTE: this is a problem with excel as opposed to Sharepoint so this would need to be done on all workstations requiring the ability to import Excel 2007 spreadsheets as custom lists.

More From pstilgoe

Blog Margeting Related Posts Plugin For pstilgoeAsk pstilgoe To Recommend Your Posts Blog Marketing Related Posts Plugin Counter

Share

Leggi tutto