Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table in hidden sheet
I need to create a pivot table in a hidden sheet and the data from that
pivot table is pulled into another sheet.. I get Error 400 if the sheet is hidden.. Right now, I have made the sheet visible before the pivot table is created and hid it after creation..I dont want the user to see the sheet being unhidden and then hid.. Is there any other way? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table - Hidden Data | Excel Discussion (Misc queries) | |||
Pivot Table - How to keep data hidden | Excel Worksheet Functions | |||
how to unhide a hidden row in a pivot table? | Excel Programming | |||
Sort Pivot Table using hidden data field | Excel Discussion (Misc queries) | |||
Pivot Table On Hidden Rows | Excel Discussion (Misc queries) |