View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Problem with ThisWorkbook.RefreshAll

Where is the source data for the pivot table? Has new data been added,
or records changed?

Vick wrote:
I have a ton of tabs and each has a pivottable on it. I've tried to use the
VBA code ThisWorkbook.RefreshAll but everytime I run it nothing happens, the
pvt table does not refresh. Does anyone have any possible reason as to why
this might be?

Thanks Vick



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html