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 |
All times are GMT +1. The time now is 02:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com