View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Vick Vick is offline
external usenet poster
 
Posts: 63
Default Problem with ThisWorkbook.RefreshAll

The source data of the document is another document. Data has been added,
but the existing records have not changed.

"Debra Dalgleish" wrote:

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