When you use the "List Formulas" feature from a Pivot Table / Chart, it generates a new Sheet in your workbook.
A simple question that I haven't found an answer to, via Google:
How can I make that sheet more dynamic? i.e. if the formulas change in my Pivot Table, then the sheet should change.
OR at least, when I click "List Formulas" to generate the sheet again, can I just overwrite the same sheet instead? The default seems to be to generate a new sheet...
I have a feeling the latter is going to be have to be resolved with a macro -- if it has to go down this route.
Bookmarks