Unhide Pivot data tab

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

Guest

Greetings. Perhaps somebody can help me. I made a pivot table several weeks
ago. It is functioning perfectly, but I hid the tab with all the data in it.
Now, I cannot unhide it. What can be done, because I do not want to have to
go back through and reenter all the data. Thanks in advance for any help.
Cheers.
 
Did you hide it, or did you delete the sheet?

If you deleted it, and want to recreate it, try double-clicking on the
grand total cell in the pivot table. This may create a new sheet with
the details.
 
Thank you, this did work.

Debra Dalgleish said:
Did you hide it, or did you delete the sheet?

If you deleted it, and want to recreate it, try double-clicking on the
grand total cell in the pivot table. This may create a new sheet with
the details.
Click to expand...
 
You must log in or register to reply here.

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

Unhiding rows in Excel 10
Access #Error & Excel Pivot 0
code to unhide tabs based on cell contents 7
Pull data from different worksheets/tab into one Pivot Table 3
Excel Error while updating an external data source into a pivot table! 0
Pivot table data source 1
Pivot pulling Multiple tabs 2
How do I get all the tabs and pages of the worksheets to appear? 3

Back
Top