I have created a manual inventory system (Dept won't buy real inventory system) in excel.
I have monthly sheets linked to the inventory items workbook. When new items are added (always) the monthly sheets display the new items.
the pivot tables have been setup for each month.
I would think that refresh updates all the links. I have even gone to Data > edit links and updated values.
Problem -- the links are updated on the monthly sheets for all new items/values Perfect
but the pivot table does not update the items/values. on refresh or edit links to these new items
I have to re-create the pivot table for the items/values to be current.
Since I have over 127 sites - the idea of re-creating the pivot tables each month for each site is impossible