Hello,
I have a spreadsheet containing over 20 pivot tables. I would like to replace the entire data set with all new data in exactly the same format with the same column names. When I do this and refresh my tables, the data fields in my pivot tables calculate correctly but the names in the drop down pivot table menus contain the data names from both the old and new data sets. Is there a way to see only the new data names?
Thank you in advance for your help!
I have a spreadsheet containing over 20 pivot tables. I would like to replace the entire data set with all new data in exactly the same format with the same column names. When I do this and refresh my tables, the data fields in my pivot tables calculate correctly but the names in the drop down pivot table menus contain the data names from both the old and new data sets. Is there a way to see only the new data names?
Thank you in advance for your help!