| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL2000 Pivot Table - Show Pages
Hi. I would like to confirm what I believe I know about the "Show Pages"
feature in XL2000 Pivot Tables. Once a Page Field's items have been spilt onto separate worksheets it is my understanding that it cannot be "undone", unless you close the workbook and start over. Is this correct? All help is greatly appreciated. Cheers, -- LPS |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
XL2000 Pivot Table - Show Pages
You could delete the worksheets that were created.
LPS wrote: Hi. I would like to confirm what I believe I know about the "Show Pages" feature in XL2000 Pivot Tables. Once a Page Field's items have been spilt onto separate worksheets it is my understanding that it cannot be "undone", unless you close the workbook and start over. Is this correct? All help is greatly appreciated. Cheers, -- LPS -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
XL2000 Pivot Table - Show Pages
Hi Dave. Yes, I knew about that as well... forgot to include it in my
message. Thanks for the confirmation about not being able to "undo" Show Pages. All the help I get from these discussion groups is terrific! Cheers, -- LPS "Dave Peterson" wrote: You could delete the worksheets that were created. LPS wrote: Hi. I would like to confirm what I believe I know about the "Show Pages" feature in XL2000 Pivot Tables. Once a Page Field's items have been spilt onto separate worksheets it is my understanding that it cannot be "undone", unless you close the workbook and start over. Is this correct? All help is greatly appreciated. Cheers, -- LPS -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When using show pages in a pivot table can I keep the page setup? | Excel Discussion (Misc queries) | |||
| Pivot Table Show Pages On Same WorkSheet | Excel Worksheet Functions | |||
| Show pages without using pivot table | Excel Discussion (Misc queries) | |||
| What happened to Pivot Table "Show Pages"? | Excel Discussion (Misc queries) | |||
| Pivot table show pages but omit those without data | Excel Discussion (Misc queries) | |||
Hybrid Mode
