Hi everyone,
I would like to have a pivot table which references a table on another tab which is basically a data dump. However, I must make sure I delete all old data before I paste the new data into the data tab table. When I delete the data, my table deletes as well, and the pivot table won't refresh (Ref isn't valid).
Is there a way to wipe out all the data on my table without deleting my table as well? Or is there a better way to do this?
Bookmarks