Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Unhide Pivot data tab
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. |
#2
|
|||
|
|||
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. coal_miner wrote: 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. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Thank you, this did work.
"Debra Dalgleish" wrote: 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. coal_miner wrote: 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. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
You're welcome, and thanks for letting me know.
coal_miner wrote: Thank you, this did work. "Debra Dalgleish" wrote: 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. coal_miner wrote: 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. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to clear data references in pivot table report | Charts and Charting in Excel | |||
Pivot table - printing specific data | Excel Discussion (Misc queries) | |||
Do Pivot Tables have an automatic data range expansion? | Excel Discussion (Misc queries) | |||
Pivot table of data in more than one worksheet | Excel Discussion (Misc queries) | |||
Need Formula to display pivot table source data | Excel Worksheet Functions |