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