Is Data Needed After Pivot Table is Created?
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 |
Is Data Needed After Pivot Table is Created?
....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 |
All times are GMT +1. The time now is 05:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com