Hey everyone, excel 2013-64 bit
Looking for help on how to lock the data table that is linked to my pivot tables in a automated report. I data dump into multiple sheets, and run a macro that deletes the oldest data (3 months previous), then shifts and renames all data.
example
table1
table2
table3
(new data) table4
after running macro
table1-deleted
table2---> shifts up to table 1 location and renamed table1
table3---> shifts up to table 2 location and renamed table2
table4---> shifts up to table 3 location and renamed table3
Now what I originally thought and set up this report that has over 90 pivot tables was that the name change of these tables would be enough for the pivot tables but the pivot tables hold the same information and just change them name of the data source.
example
pivot table that was pulling from table3 in old dataset now runs on table2 information instead of table3 (which is the new data), which is what i'd like it to pull from
the only solution I've been able to come with is to edit the all the pivot tables to data source specific cells instead of tables.
Any ideas out there?
Looking for help on how to lock the data table that is linked to my pivot tables in a automated report. I data dump into multiple sheets, and run a macro that deletes the oldest data (3 months previous), then shifts and renames all data.
example
table1
table2
table3
(new data) table4
after running macro
table1-deleted
table2---> shifts up to table 1 location and renamed table1
table3---> shifts up to table 2 location and renamed table2
table4---> shifts up to table 3 location and renamed table3
Now what I originally thought and set up this report that has over 90 pivot tables was that the name change of these tables would be enough for the pivot tables but the pivot tables hold the same information and just change them name of the data source.
example
pivot table that was pulling from table3 in old dataset now runs on table2 information instead of table3 (which is the new data), which is what i'd like it to pull from
the only solution I've been able to come with is to edit the all the pivot tables to data source specific cells instead of tables.
Any ideas out there?