Is Data Needed After Pivot Table is Created?

G

Guest

I've noticed that the original data for a pivot table can be deleted and the
pivot table is maintained, including drill-down capability. Is the original
data needed for anything (other than a refresh, if you want to change the
data) once the pivot table has been created?
Will
 
G

Guest

....depends on your pivot table settings. sometimes it may refresh on
re-opening the file. Best rule of thumb is to leave the source data there
for any active pivot table. Another option is to highlight the pivot table
and "paste as values". You lose your "drill down" ability, but it it will
keep the same apperance and data. It may make sense for whatever you are
doing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top