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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding to an existing Pivot Table 7
Excel VBA For excel 0
Are copied Pivot Tables "linked" to each other ? 2
Refreshing Pivot Table on a protected spreadsheet tab 1
Linking Pivot Table data 3
Pivot Table Update 3
Pivot ungrouping on refresh? 3
Pivot table 1

Back
Top