| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
