Problem with ThisWorkbook.RefreshAll
 

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

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

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

Problem with ThisWorkbook.RefreshAll
 

Perhaps the pivot table's source range doesn't include the rows with the
new records.
Right-click on the pivot table, and click on PivotTable Wizard.
Click Back, and see if all the rows are included.

Vick wrote:
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





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