Error "Couldn't get data from the Data Model"

[dariusd77]

I keep getting the following error when I try to refresh a pivot table (not Power Pivot).
"We couldn't get data from the Data Model. Object reference not set to an instance of an object".

I tried re-selecting the data source, but would get the same error message. I checked to see that I have all updates for Excel 2016 so that is not the issue. Is there any hot fixes for this error, or solutions that do not involve recreating all the pivot tables and charts?

Thanks for your help

 

[Weazel]

try closing out excel completely then reopening your workbook and refreshing.

I've noticed sometimes that it might be necessary to check the task manager prior to reopening and making sure there aren't any instances hanging in the background

 

[dariusd77]

Yeah i tried that..but it didn't work.