ExcelBanter - GETPIVOTDATA returns #REF error

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - GETPIVOTDATA returns #REF error (https://www.excelbanter.com/excel-worksheet-functions/72775-getpivotdata-returns-ref-error.html)

yanf7

GETPIVOTDATA returns #REF error

Hello,
I have a report that is updated from the pivot table on another
worksheet.
Getpivotdata returns the results, but when I close the file with the
pivot table, the result is #REF!
Can someone help to solve this issue?

--
yanf7
------------------------------------------------------------------------
yanf7's Profile: http://www.excelforum.com/member.php...info&userid=19
View this thread: http://www.excelforum.com/showthread...hreadid=514479

All times are GMT +1. The time now is 09:32 AM.