Excel 2010 Pivot Table Drilldown - Update Source table?

[MeGustaXL]

Hi,

I've got a Pivot Table based on a Source Table that is 25,000+ Rows by 75 columns.
When I drill down into the Pivot Table, it understandably unearths the odd data error, duplicate, incorrect entry, etc. Correcting these is easy if there's just one or two - each row in the Source Table has a Record Number in column A, so I go to the table and amend the cell directly.

Sometimes though, there are many, many records in the drilldown, and these may have several amendments needed. Is there a way to make changes in the Drilldown output table, then have them 'refresh' or 'flash through' to the Source Table?

At the moment, I use an Advanced Filter on the Source Table, with Criteria based on the Record Number from the Drilldown Table. Is there a 'smarter' way to do it?

Chris

Someday I'll know what I'm donig...damn!

 

[combo]

There is no way to modify source data via pivot table report.
Microsoft developed Pover Pivot, that is succesively being implemented in excel (2016: native functionality, 2013: free add-in, 2010: add-in that works in professional plus version). It's a powerful tool to manipulate data, either for an input for pivot table or to get final table. A query in PQ is a series of transformations, filters or formulas, including various joins of other tables/queries.
If you have any chance to use it, I highly recommend it.

Pover query is also a part of microsoft's business inteligence suit Power BI (

https://powerbi.microsoft.com/en-us/),

one of versions is free, I tested it few months ago, it's close to excel's 2016 (professional version) business inteligence package: Get & Transform (Power Query), Pover Pivot and Pover View.


combo

 

[MeGustaXL]

Thanks combo, that's what I thought, more or less.

No dice on the Power Pivot, the computer and Excel 2010 are the Company's, and downloads are blocked :-(

Chris

Someday I'll know what I'm donig...damn!