Linking to Pivot Table

  • Thread starter Thread starter Del
  • Start date Start date
D

Del

I would like to link a cell in a worksheet to a subtotal
cell in a pivot table which gets updated when the pivot
table is refreshed. The pivot table is updated monthly
with new lines added but so far the link has not updated
itself to the new sum but stays looking on the cell above.

Is there any settings which can be changed to rectify this?
 
You can use the GETPIVOTDATA function to link to data in a PivotTable.
Check Excel's online help for examples specific to the version that
you're using.
 
Back
Top