Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 77
Default how to undo a pivot table

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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Top 5 plus Other in Pivot table almpk Excel Worksheet Functions 1 July 19th 06 10:29 PM
Derived Columns in Pivot Table sa02000 Excel Discussion (Misc queries) 1 February 8th 06 08:18 PM
Using a Pivot Table Calculated Field to get a Unique Count Mike Struckman Excel Worksheet Functions 1 November 22nd 05 06:32 PM
Pivot -- want to use Max and Sum in same table Dave Excel Worksheet Functions 1 July 13th 05 04:37 AM
how to delete/clean out the row list in pivot table john² Excel Worksheet Functions 1 May 26th 05 04:56 AM


All times are GMT +1. The time now is 11:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"