can i change pivot table to change data

J

jacob22

I need to be able to edit the the data on the pivot table and have it change
in the data field. Is there a way to make this happen?
thanks
 
D

Dave Peterson

I don't think so.

The pivottable is a summary. If that quantity is a summary of 7342 records of
data, how would you ever know which one record should be updated--or which
records should get what portion of that update?
 
J

Jim Thomlinson

Depends but I highly doubt it. The only way to write back would be if you had
a cube that was created through Analysis Services, then you could write back
to the cube. That still does not go all why way back to the source data
however. If your pivot table is created from data stored directly in the
sheet then there is no way to write back to the source data.

If you are talking about a Cube that was created via Analysis Services
(comes with MS SQL Server) then with an addin such as Cube Analysis and an
understanding of MDX query language, it is possible to write back to the cube.
 
Top