Haukwa Wrote:
jgp_2

Right-click on the Pivot Table and select Table Options. Enable
'Refresh on Open'. This will refresh the Pivot Table data everytime
the workbook is opened.

Does that help?

Gerry

Thanks for your help, Gerry! I scanned over that option and didn't
notice it Must be thinking about the long weekend:)

Thanks again!!


--
jgp_2
------------------------------------------------------------------------
jgp_2's Profile: http://www.excelforum.com/member.php...o&userid=27624
View this thread: http://www.excelforum.com/showthread...hreadid=487377