Jun 04 2017 10:51 PM
I would like to edit the source of a pivot table. But I've got a huge amount of data to go through and find the source cell as there are many duplicates. So is there a way to find the source cell of a selected data in the pivot table.
Is there any way we could hyperlink the pivot table so that if we ctrl+click, it could take us back to the parent cell?
Jun 05 2017 01:09 AM
Feb 04 2018 01:12 AM
Feb 04 2018 03:16 AM
Sep 09 2022 08:36 AM
This is DEF a feature they should add, as I have been needing to do this EXACT thing so many times. If they made this a feature, it would save a lot of time for us if we could somehow jump straight from the pivot chart cell to that cell in the parent data list. The double clicking is not exactly what we are looking for, but thank you for the suggestion. Excel is so powerful and they have thought of so many ways to help us. They just need to add some more to help us all the best possible ways.