G
Geoff
When I setup a GETPIVOTDATA function across multiple
(roughly 200)worksheets in a workbook a #REF! appears and
the workbook is locked into an endless loop. After I
write the formula I get the correct answer but, when I do
a manual calc (Ctrl F9) I get a #REF! The pivot table is
in a different workbook but it is open when I write the
formula and do the manual calc. How can I get the
GETPIVOTDATA function to return the correct answer?
(roughly 200)worksheets in a workbook a #REF! appears and
the workbook is locked into an endless loop. After I
write the formula I get the correct answer but, when I do
a manual calc (Ctrl F9) I get a #REF! The pivot table is
in a different workbook but it is open when I write the
formula and do the manual calc. How can I get the
GETPIVOTDATA function to return the correct answer?