Pivot table data

[kristell]

Hi - hopefully, this is just a simple question, but I can't' find the answer!

I have a pivot table for which the data source is quite large. Is there any way to click on a cell in the pivot table and it take you to the original cell in the data source so that I can edit a mistake that I have noticed. e.g. the same company name has been misspelt, or a town, or anything!

At the moment I am copying from the pivot table and then searching my data source to find the erroneous entry - but wondered if there was a quicker way to edit the original data source and then go back and refresh the pivot table.

Many thanks.

 

[ashakantasharma]

It is not possible in Pivot Table. However you can do so with CTRL+{ on any formulas to get to the source of the same.

 

[kristell]

Thank you for your reply. Shame you can’t do it as it would be so much easier!