This macro is cool, D. It refreshes the pivot table whenever you click on
the worksheet on which it resides.
http://vbaexpress.com/kb/getarticle.php?kb_id=80 Perhaps that will work for
you.

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"DMithias" wrote in
message ...

Ok... I'm just beginning to learn how to use macros so please be kind.


I have a report that pulls totals from a pivot table on another tab
using a vlookup. I want to add a command button on the report tab that
I can click and refresh the pivot table on the other tab.

If anyone has some good code for this or else can point me to a good
source it would be much appreciated.

-DM


--
DMithias
------------------------------------------------------------------------
DMithias's Profile:
http://www.excelforum.com/member.php...o&userid=31322
View this thread: http://www.excelforum.com/showthread...hreadid=510188