Question

I have developed a spreadsheet that has 1 page with all the data. There are approximately 20 pivot tables showing different information from the page. The data area has been named Info, so all the pivot tables refer to the area named info.

My problem is, every time the client copies new data onto this sheet and the area is renamed, the data is totally different from the previous data. There is a button that the client clicks to refresh all the pivot tables. But the pivot tables keep the previous headings in the lists, so the lists are just getting longer and longer, it does not get rid of the headings that no longer exist in the Info.

What can I do to rectify this problem? Please help, as the Pivot tables are getting out of hand and then errors start appearing that the pivot table cannot overlap.

Thank you so much for your help
Alta Niemandt
South Africa