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)
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)
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