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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot table + fixed column fields
*The source file for the pivot tables is updated on a weekly basis. * How do you update the source file? Is the source file and Excel document? 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. * How do you decide which ones to remove? I was wondering if there was anyway to "fix" the column fields so that this manual function was no longer necessary? It's difficult to say without seeing some kind of sample. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot table + fixed column fields
On Sep 30, 1:45*pm, dan dungan wrote:
*The source file for the pivot tables is updated on a weekly basis. * How do you update the source file? Is the source file and Excel document? 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. * How do you decide which ones to remove? I was wondering if there was anyway to "fix" the column fields so that this manual function was no longer necessary? It's difficult to say without seeing some kind of sample. The source file is a separate excel file. I cannot share it as it is proprietary. The source file has 30K+ rows of data. Each rows has details specific to a part by date. There are hundreds of parts that are updated to this file on a weekly basis, but I only need the data on a dozen. Right now I manually uncheck the ones I don't want in the column field of the pivot table. The source excel file as it is updated on a weekly basis sometimes gets additional parts added to it as new production proceeds. I do not need the data for the new parts, only the specific dozen I have checked, but when I refresh my pivot table, I get the new parts which I have to manually remove each week. I want to know if there is a way to prevent new parts from being added to the pivot table. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot table + fixed column fields
In Excel 2000, I would chose Get External Data from the Data menu and
create a New Database Query to filter only the part numbers you seek. Then I generate the pivot table from that data. |
Reply |
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 |