Avatar of Robert Berke
Robert BerkeFlag for United States of America

asked on 

can excel 2016 jump to source rows from a pivot table cell ?

When viewing a pivot table, I often discover "bugs" in the source data.  For instance pivot summary by part name might reveal that part number 1234 has misspellings of the name.

I have often wanted a "jump to source" feature which allows me to correct the source easily.

Solution #1 is to double clicking on the pivot table cell which creates a nice copy of the source rows.
Unfortunately, to fix the incorrect rows, I still have to jump around quite a bit.

Solution #2 I found PTCellFilterExcelDataSource contextures.com which has a Demo  that works perfectly - I double click a pivot table cell and I drill down to the source sheet. It is filtered to show only the associated rows.

Unfortunately, PTCellFilterExcelDataSource  is pretty complicated, and too much effort for the quick and dirty projects I usually encounter.

So I wonder if Excel 2016 has finally incorporated a simple "jump to pivot source" procedure?  If so, I think it is time for me to upgrade.

rberke
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Professor J
ASKER CERTIFIED SOLUTION
Avatar of Professor J
Professor J

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Microsoft Excel
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo