• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

When I type a formula referencing a pivot table, I cannot copy the formula d...

When I type a formula referencing a pivot table, I cannot copy the formula down

Problem

If you are working with Excel 2002 or a later version, you will find that Excel has an annoying default setting that revolves around the GetPivotData function.

Excel automatically inserts the GetPivotData function into any cell where you are trying to enter a formula referencing your pivot data. The issue is that the GetPivotData function automatically references the cells in your pivot table as absolute references, making it impossible to simply copy your formulas down and get the right answer.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint