If the location of your data moves then GETPIVOTDATA will still return it, assuming it’s still visible somewhere in your PivotTable report. If you link to a cell in a PivotTable with a regular cell reference and then the location of that data changes due to a refresh, or a filter or Slicer being applied, then all of a sudden your formula is returning the wrong information. Why? Well, PivotTable reports are typically being updated and, or changing shape as you add new data to the source and alter filters etc. However, the benefit in using GETPIVOTDATA, as opposed to a regular cell reference, is huge in terms of reducing your ongoing workload in maintaining your reports. ![]() Understandably so, because in its default form it’s quite inflexible. In its simplest form the Excel GETPIVOTDATA function enables you to extract values from a PivotTable report, but if you’re like me when you first tried to figure out how to use GETPIVOTDATA, you were less than pleased with the results. Excel for Decision Making Under Uncertainty Course.Excel for Customer Service Professionals.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |