View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] cfranklin@ecosure.com.au is offline
external usenet poster
 
Posts: 1
Default Removing Pivot Table Functionality

I have produced a Pivot Table and want to use it as a base to add
further information from other areas. I have copied and pasted the
Pivot Table to a new spreadsheet. I can not work out how to remove the
Pivot Table functionality (leaving the information created by the
pivot table) to create a normal spreadsheet that can then be
manipulated further.

Please advise how I can remove the original pivot table functionality
to create a normal excel spreadsheet?

Thanks for your help.