#ProjectServer 2010 #Excel Services Reports fail to Refresh #Office2013 #SP2010

November 23, 2012 at 3:43 pm | Posted in Administration, Configuration, Functionality, Information | 1 Comment
Tags: , , , ,

A quick post to highlight an issue you may face if you have upgraded to Office / Excel 2013. I recently created some Excel reports for Project Server 2010 using Excel 2013. These reports failed to refresh in Excel Services. After a quick check on the connection string in Excel, the provider is MSOLAP.5 rather than the usual MSOLAP.4 provider when using Excel 2010. See below

Excel 2010:

image

Excel 2013:

image

The ULS log error is:

The workbook ‘http://vm730:81/pwa/ProjectBICenter/Reports/Actual Work.xlsx’ attempted to access external data using the unsupported provider ‘Provider=MSOLAP.5

The fix is very simple, navigate to Central Admin > Manager Service Applications > Excel Services > Trusted Data Providers then add the MSOLAP.5 provider as below:

image

Advertisements

1 Comment »

RSS feed for comments on this post. TrackBack URI

  1. […] This article has been cross posted from pwmather.wordpress.com (original article) […]


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

Create a free website or blog at WordPress.com.
Entries and comments feeds.

%d bloggers like this: