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