M
Mike
Follow these steps when you get new data for the pivot
table:
1. delete the old data
2. paste the new data in its place
3. adjust the range of cells to fit the new data
4. refresh the data on the pivot table
The pivot table should have only current information in
the drop downs.
table:
1. delete the old data
2. paste the new data in its place
3. adjust the range of cells to fit the new data
4. refresh the data on the pivot table
The pivot table should have only current information in
the drop downs.