View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
snax500 snax500 is offline
external usenet poster
 
Posts: 49
Default Convert Pivot to Table w Formulas

In Excel2007, I want to convert a pivot table to regular table with
formulas. Currnetly I have to copy the pivot and paste special values
and manually add back my formulas, ex =SUM. Is there a more efficent
way of doing this?The reason I do this is that once I have my pivot
data, I want to change some of the data but not from the data source.

Thanks