View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default can i change pivot table to change data

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?



jacob22 wrote:

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


--

Dave Peterson