| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I save a pivot table layout?
Ok what I've done is simply go 2 steps back via the wizard to a new set of
data- usually a transposed sheet of original data. Sometimes I need to add new flelds to the data, sometimes not. I use Deborah's fantastic pivot table addin to reset all data fields to 'Sum of' & procede from there. No code, just a few easy , repetitive steps. Cheers now, Rob. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| Auto refresh pivot table on Save | Excel Discussion (Misc queries) | |||
| how to delete/clean out the row list in pivot table | Excel Worksheet Functions | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
Hybrid Mode
