Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refresh a Pivot Table
I have a pivot table report that is generated by a table in Access. Often, I
create a Pivot table on the first worksheet within the workbook and then create subsequent Pivot tables on subsequent worksheets. My question is why do I have to relink (Get Data) the Excel Pivot table when a new field has been added to the Access table? Is there a setting that we could change to have this happen automatically when the Excel file is open? Thanks! Jeannette |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
refresh a new worsheet on pivot table refresh | Excel Worksheet Functions | |||
Pivot Table Refresh | Excel Discussion (Misc queries) | |||
pivot table will not refresh | Excel Discussion (Misc queries) | |||
Pivot Table Refresh | Excel Worksheet Functions | |||
Pivot Table refresh | Excel Discussion (Misc queries) |