Forum Discussion
dynamic display of pivot table item details
Right-click on a cell in a pivot table and "show details" will give you fixed list in a new worksheet of the items underlying the entry. I would like this to be dynamic so it would show the items for that cell as they changed according to changes in the parameters I use to define the data in the underlying data. Any ideas on how to do this without VB programming? This is Excel on a Windows Surface Pro 4 (can't find the version info). Thanks.
2 Replies
This is a very belated thank you. Perhaps because I had not provided my profile with an email address, I never saw this at the time and shortly thereafter abandoned development of the relevant spreadsheet. I have now returned to it and see your reply. I haven't tried it yet, but the code you linked me to may provide the needed functionality.
