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.