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

Double-click on the Grand Total cell, and it should create a sheet with
all the underlying records for that total.

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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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

Awesome that worked, and it was so easy. Thanks

"Debra Dalgleish" wrote:

Double-click on the Grand Total cell, and it should create a sheet with
all the underlying records for that total.

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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html