kristell
New Member
- Joined
- Dec 12, 2014
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
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.
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.