| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot table + fixed column fields
I can't seem to find an answer to my problem so I thought
I would take a stab and see if it is even possible to do.... I have several pivot tables where I track data on about a dozen parts. The source file for the pivot tables is updated on a weekly basis. There are hundreds of parts and several are added weekly, but I only need the data on a specific 12 or so parts. Whenever I refresh my pivot tables I get these new parts that I don't want. I have to manually remove them from the column fields. I was wondering if there was anyway to "fix" the column fields so that this manual function was no longer necessary? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table multiple column fields | Excel Discussion (Misc queries) | |||
| Pivot Table Options 'Fields per column' | Excel Discussion (Misc queries) | |||
| Pivot table: showing COLUMN summaries for some, not all, COLUMN fields. | Excel Programming | |||
| Pivot Table Column Widths will not stay fixed... | Excel Discussion (Misc queries) | |||
| How to get data from pivot table with multiple column fields? | Excel Programming | |||
Threaded Mode
