View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default how to undo a pivot table

If you create a pivot table, the original table isn't removed. It should
still be in the workbook, on its original sheet.
Click on the sheet tabs at the bottom of the Excel window. Your original
data may be on Sheet 1.

laura wrote:
i had a spread sheet and accidentally made it into a pivot table. the pivot
table is now blank and i cant retrieve the original table that was on a
standard spreadsheet, undo wont work!



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