Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 25th 06, 12:01 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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  
Old August 25th 06, 12:33 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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 07:18 PM
Using a Pivot Table Calculated Field to get a Unique Count Mike Struckman Excel Worksheet Functions 1 November 22nd 05 05: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 10:00 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017