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.