RSS

Unable to Load Workbook – MOSS 2007

29 Oct

We had a user upload an Excel document and when I opened it, it worked fine but when other users opened it they received the following:

ExcelError

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

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.

This really threw me off but ultimately what I found was that the Excel spreadsheet was created in Office 2007 with the .xlsx extension and the users having issues were trying to open it in Office 2003. It’s a very simple solution to a weird SharePoint issue. Another solution if this is not your issue is that IE is opening the document via the Web Browser instead of directly through Excel. If so, check your Internet Options and Programs list to see what the default program those file types are opening in.

I did find that there are certain things that aren’t compatible with SharePoint using Excel such as external data tables but the only good info I could find on this was to convert them to pivot tables and they should work although I have not tested this. Here is a link for the following error:

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

External data ranges (also called data ranges)

Contact the workbook author.

http://blogs.microsoft.co.il/blogs/itaysk/archive/2007/11/08/using-external-data-in-excel-services.aspx

Advertisements
 
Leave a comment

Posted by on October 29, 2009 in SharePoint Common Issues

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: