Refreshing Data Based On A Pivot Table

[HomeTek]

Hi all,

So I have a pivot table and I know if a change is made to the source data I can simply refresh the pivot table to update it.

However, is there a way to refresh the new sheet that is created when you double click on the total within the pivot table for example? Pressing refresh on the pivot table of course has no effect on that worksheet, it will still contain old incorrect data and you'd need to create another work sheet.

I'm not too sure if I'm making much sense here.

 

[Fazza]

If I understand correctly, you know the answer to the question. "Pressing refresh on the pivot table of course has no effect on that worksheet"

 

[HomeTek]

If I understand correctly, you know the answer to the question. "Pressing refresh on the pivot table of course has no effect on that worksheet"

Yeah it can't be done that way. I'm asking if there is a way it can be done. Whether that be via the ribbon, formulae, VBA, anything other than manually.

I've got a bunch of macros that does a whole load of different calculations, graphs etc, and I can get everything automated other than this part which I have to do manually every time there is new data.

 

[Fazza]

Sounds like a job for VBA.