If you copy and paste a PivotTable, what will happen?
Understand the Problem
The question is asking what happens when you copy and paste a PivotTable in Excel, specifically regarding the cache and memory implications involved in this action.
Answer
The second PivotTable will use the same cache, or snapshot, of your data.
The second PivotTable will use the same cache, or snapshot, of your data.
Answer for screen readers
The second PivotTable will use the same cache, or snapshot, of your data.
More Information
Copying a PivotTable typically means the new table will use the existing data cache. This allows both tables to be updated simultaneously when the source data changes.
Tips
A common mistake is assuming the pasted PivotTable always creates a new cache, which is not usually the default behavior.
Sources
- Copying and Pasting in Data Tables - help.pivotinteractives.com
Thank you for voting!
