Forum

Can the Data Source...
 
Notifications
Clear all

Can the Data Source be Updated from a Pivot Table?

3 Posts
2 Users
0 Reactions
60 Views
(@jaynemae)
Posts: 3
Active Member
Topic starter
 

I am using MS Excel 2010. Is there any known way to update the data table directly from a pivot table? In other words, I would like to be able to change a figure in a pivot table and have this change automatically reflect back to the data table. Is this even possible?

 
Posted : 07/07/2016 8:59 am
(@catalinb)
Posts: 1937
Member Admin
 

Hi,
A pivot table is not editable unfortunately, it will only take data from source, it will never send data to source.
Catalin

 
Posted : 07/07/2016 1:07 pm
(@jaynemae)
Posts: 3
Active Member
Topic starter
 

I was afraid that someone would verify that. Darn, now my bubble has completely burst! Confused Thank you for taking the time to respond. I do appreciate your response.

 
Posted : 08/07/2016 7:48 am
Share: