This is a link to the Project Server PFE Team Blog. PFE’s are Premier Field Engineers, support Project Server around the globe, and contribute to this blog.
Hotfix
Unable to access ODATA via Excel 2013
On April 9th 2014 a number of updates were applied to my laptop and after that I was unable to access the ODATA feeds. Excel returned the following error: Invalid pointer array
To resolve the issue I had to apply the following hotfix: http://support.microsoft.com/kb/2837666
You experience one of the following problems if you have recently applied the October 2013 Cumulative Update for Excel (KB 2825655) or a later version, but you have not updated your version of the PowerPivot add-in:
- When you try to access data modal from a pivot table, you receive the following error message:
We couldn’t get data from the Data Model. Here’s the error message we got:
Invalid pointer array - You cannot refresh pivot tables, and no updates seem to occur.
- You cannot launch the PowerPivot | Manage window from the ribbon.