Unhide Pivot data tab

C

coal_miner

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

Debra Dalgleish

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

coal_miner

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