Ask Your Question
0

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

asked 2014-09-29 17:26:34 +0200

djwilli gravatar image

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)

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-04 11:34:59.515603

1 Answer

Sort by » oldest newest most voted
0

answered 2014-09-30 00:00:34 +0200

m.a.riosv gravatar image

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

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-09-29 17:26:34 +0200

Seen: 1,254 times

Last updated: Sep 30 '14