Power view error while opening excel fine in SharePoint 2010

I am getting an error while opening an excel file:

"The following features are not supported in the browser and might not display or might display only partially: 
Comments, Shapes, or other objects 
Some features, such as external data queries, display cached data which can only be refreshed in the client version of Excel."

Is this issue browser related or SharePoint related?

February 12th, 2015 5:10am

Hiya,

it depends what that file contains. There are a lot of new features for Excel, Excel services in the newer versions of SharePoint and SQL server. So it really depends on which of these features your using in your excel file.

What version is your SharePoint and SQL server(database services) and SQL Reporting?

There is a pretty specific article for that error message relating to PowerPivot.

https://msdn.microsoft.com/en-us/library/ff487973.aspx

And some additional information on Excel services

http://blogs.office.com/2005/12/01/excel-services-part-12-unsupported-features/

Free Windows Admin Tool Kit Click here and download it now
February 13th, 2015 12:58pm

Hiya,

it depends what that file contains. There are a lot of new features for Excel, Excel services in the newer versions of SharePoint and SQL server. So it really depends on which of these features your using in your excel file.

What version is your SharePoint and SQL server(database services) and SQL Reporting?

There is a pretty specific article for that error message relating to PowerPivot.

https://msdn.microsoft.com/en-us/library/ff487973.aspx

And some additional information on Excel services

http://blogs.office.com/2005/12/01/excel-services-part-12-unsupported-features/

February 13th, 2015 12:58pm

I am getting this error while using PowerView reports. 

I am trying to open the excel in IE browser (from SharePoint 2010)

Free Windows Admin Tool Kit Click here and download it now
February 17th, 2015 4:36am

What version of SQL have you installed? (Reporting Services) - not that database services.

February 18th, 2015 3:37am

What version of SQL have you installed? (Reporting Services) - not that database services.

Free Windows Admin Tool Kit Click here and download it now
February 18th, 2015 11:36am

There is no connection to db, data is in excel sheet cells itself.
February 23rd, 2015 4:42am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics