Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Top 5 plus Other in Pivot table | Excel Worksheet Functions | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
how to delete/clean out the row list in pivot table | Excel Worksheet Functions |