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

Troubleshooting

Inserting PivotTables

When I click a PivotTable, it automatically inserts the PivotTable formula. How can I get around this?

If you want toreference a cell in a PivotTable but do not want Excel to write a PivotTable formula in that cell, do the following: Type =B4 if B4 references a cell in the PivotTable. Don't click the PivotTable. This is important because when you are creating an extended list from a PivotTable, you can then drag the formula down with relative referencing.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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