Getting a #REF! error after changing the source data on GETPIVOTDATA

[djwilli]

I have a spreadsheet I need to update. When I change the source and refresh the Pivot table the GETPIVOTDATA function returns #REF! errors

=GETPIVOTDATA(“Sum of Products # Businesses”,$‘Customer Name’.$A$10)

[mariosv]

I think I have seen this issue, updating Pivot Table gives right values again.

In this link you can find a macro to update all Pivot Table at once.
MacroUpdatePivotTable