how to undo a pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table - undo of a macro 1
Undo "Convert to formulas" pivot function 1
Pivot Table - Changes 5
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot table filter list - listing irrelevant subcategorys 1
Adding to an existing Pivot Table 7
Are copied Pivot Tables "linked" to each other ? 2
Referencing a pivot tables Grand Totals Column 1

Back
Top