Link to home
Create AccountLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Excel - Double clicking on pivot cell brings up raw data

Hi

In a spreadsheet that I was given: when a user double clicks on a cell inside a pivot table (shown in the first image marked by the purple arrows) it adds a new sheet containing raw data in a table (shown in the second image: this seems to be the source data)

There is no VBA in the file so I have no idea how this works or where the raw data resides.

So as an example if Australia is double clicked on a new sheet is added on the source data filtered by Australia


User generated imageUser generated image



ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.