I'm just starting to get more familiar with Excel's pivot tables and their functions. I've noticed that changing the grouping on one table affects the grouping on another table, even though they are completely separate pivot tables.
Turns out this is Excel's "data caching" in order to save memory and disk space. Great, I'm very happy Excel's saving disk space on my whopping 300 records of data, but this reminds me of Office's warnings of having a "large amount" of data left on the clipboard.
Um, hello, Office dev team, it's 2014. Let's raise that bar of what a "large amount" of data really is.
Tangent. Back to pivot table grouping.
See here: http://office.microsoft.com/en-us/excel-help/unshare-a-data-cache-between-pivottable-reports-HA010226675.aspx
No comments:
Post a Comment