Microsoft Access Tables / Microsoft Excel Pivot Tables

[PJname]

I am using MS Access data tables to run in MS Excel to update graphs using the Pivot table option.

I haven't used the Pivot table option very much and I am struggling to understand how it works.

I am able to include the MS Access tables containing the data using Pivot table, but I have noticed that if I add or remove a field name in the MS Access data table, it still shows these field names in the Pivot table in Excel. I thought that when I performed the Refresh Data it would load only what is currently in the MS Access data table. Apparently this is not the case.

The only way that I have found to correct is to delete old Pivot table and insert again.

Is there a better way to do this?

I am really getting frustrated since I have about 20 files that is to be updated.

Please help!