View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Shailesh Shah Shailesh Shah is offline
external usenet poster
 
Posts: 17
Default Return pivot table fields to their original value after editing


You can lock the cells & protect the sheet.

Regards,

Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.

"Matt Bailey" wrote:

Pivot table fields can be edited and renamed by mistake quite easily. Where
this has been done, I am having trouble re-writing the correct values to the
pivot table, despite the fact that the database containing the data, still
shows the correct data. I have tried refreshing the data, have looked at all
the pivot table options and tried changing the field settings without success.

I am using Microsoft Excel 2003 SP1