View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
loudfish loudfish is offline
external usenet poster
 
Posts: 49
Default reverse a pivot table

On 18 May, 18:39, cyndi wrote:
I am using Excel 2003, I was sent a excel document as an attachment with a
pivot table, the original data to which the pivot table was linked was not
attached, is there a way to get the data back to just coloumns, I don't care
about formatting. I just need it out of the pivot table.

Thank you


Have you tried double-clicking on the grand total at the bottom corner
of the pivot. If the entire dataset is included, this should give you
a new worksheet, with all the underlying data.

HTH

Andrew