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

....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.

"roadkill" wrote:

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