Forum Discussion
How to go back to the parent cell of a cell in pivot table?
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 ...
This will create a separate worksheet with data which contribute the selected pivot table value. But what I want to achieve is to double-click on a value to go back to it's parent cell and edit it in the data source. Is this possible?
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.
- I second.
