Need to edit cell values in pivot table and want it to update original source data

**ChaBun** · 02-18-2021, 08:46 AM

Hi, is this possible?

I need to edit a cell value within the pivot table and want the original source data to be updated. I know if I edit the source data I can refresh the pivot but is there a way to do this in reverse?

**Pepe Le Mokko** · 02-18-2021, 09:32 AM

Hi
as data from a PT is a consolidation of the source data I don't think this is possible.
Why would you want to do that?

Need to edit cell values in pivot table and want it to update original source data

LinkBack

Thread Tools

Rate This Thread

Display

Need to edit cell values in pivot table and want it to update original source data

Re: Need to edit cell values in pivot table and want it to update original source data

Thread Information

Users Browsing this Thread

Similar Threads

Add custom column to Pivot Table or update Source data FROM pivot table

using VBA to update a pivot table data source

Update source data from pivot table

Is there a way to update the pivot table as data is added to the original worksheet?

how to update pivot table when new rows/columns are added to the original data?

Original Source of Pivot Table Data

How to edit pivot table data source??

Bookmarks

Bookmarks

Posting Permissions