Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
compile error in hidden module: thisworkbook | Excel Discussion (Misc queries) | |||
ThisWorkbook of personal.xls | Excel Discussion (Misc queries) | |||
ActiveWorkbook.RefreshAll | Excel Discussion (Misc queries) | |||
Compile error in hidden module: ThisWorkbook | Excel Discussion (Misc queries) | |||
Compile error in hidden module: ThisWorkbook | Excel Discussion (Misc queries) |