| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table totals
I discovered a neat trick in a pivot table. When i double click on the total
cell, it opens up another worksheet (sheet2) and expands the data, but it opens a new worksheet each time(sheet3, sheet4 etc). Can i have it open in the same sheet each time. I'd like to use the data to form the basis of a standard letter and drop the data in the same spot each time. -- Browny |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table totals
Browny I doubt that is possible.
The "trick" also works for all cells in Pivot Tables not just the total cell. "Browny" wrote: I discovered a neat trick in a pivot table. When i double click on the total cell, it opens up another worksheet (sheet2) and expands the data, but it opens a new worksheet each time(sheet3, sheet4 etc). Can i have it open in the same sheet each time. I'd like to use the data to form the basis of a standard letter and drop the data in the same spot each time. -- Browny |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table totals | Excel Discussion (Misc queries) | |||
| Pivot table totals? | Excel Discussion (Misc queries) | |||
| Help with Pivot Table and totals | Excel Worksheet Functions | |||
| Totals in Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table Chart - With Pivot Table Totals | Charts and Charting in Excel | |||
Linear Mode
