I just took over a new position in my business and have some questions about pivot tables. The job position already has many pivot tables created and have been used for months. I have about 3 questions:
1) all pivot tables reference a text sheet about 4500 rows and 28 columns. I need to change this data weekly. when I change it I can do is several ways but hte best is to delete and cut and paste to replace data. The problem is the new data will have 4700 rows but column will always stay at 28. when I do this will I ruin the pivot tables or will I have to go to each pivot table and change the ref cells individually.
2) can this whole process be automated?
3) The sheet that I replace since the parameters will vary a little more or a little less every time, so would it be prudent to always reference a round figure like 4800 and just deselect blanks. I think this will work.
4) lastly, when I change the whole sheet will this corrupt the pivot tables. I've tested and didn't noticed anything wrong but not sure if it was a proper way of doing business.
Thanks in advance appreciate your patience