| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically Refresh pivot table
What is your trigger to refresh. When you open the book or every ?? minutes?
or... There are some options in Table Options. Right click the pivot table and select Table Options. At the bottom are the refresh options (IIRC for 2000). -- HTH... Jim Thomlinson "Shell" wrote: In Excel 2000, I have a spreadsheet with several table. Some of the tabs have been filled with data from an Access MDB. I have manually created a second tab which contains a pivot table based on the data I passed in to the ther tab. The source data tab always has a different number of rows every time the Access MDB is executed. How can I automatically refresh the pivot table? Thanks -- Shell |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| slow document / pivot table refresh and pivot function | Excel Discussion (Misc queries) | |||
| Automatically Refresh Pivot Table Data | Excel Worksheet Functions | |||
| Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
| refresh a new worsheet on pivot table refresh | Excel Worksheet Functions | |||
| Refresh Pivot Table Automatically | Excel Discussion (Misc queries) | |||
Threaded Mode
