Hi all. Newbie to this forum and a beginner user in pivot tables, but 8 months ago I created a multiple sheet pivot table from two sheets whose data columns were different (can't remember doing this, but I did). For the past 8 months I've been refreshing the sheets with data from Access tables and refreshing the pivot tables daily.

I've been asked to create a 30 day average of an existing 28 day moving average and add the values to the current pivot table. I've added the column and calculations to one of the original data sheets that feeds the pivot table and refreshed the pivot table. My problem is .... when i pull up the available field list, the newly added data element is not an option to add to the pivot table. Without starting from scratch and creating a new multi-sheet pivot table, is there a way to have the new column become available via drop down menu on the pivot table field list selection box?
If this is possible it would save me tons of time trying to remember how I did this in the first place.

Any suggestions would be tremendously appreciated.
Thanks in advance for help!
Peter