pivot table + fixed column fields

[Opal]

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?

 

[dan dungan]

 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.

 

[Opal]

How do you update the source file?
Is the source file and Excel document?

There are hundreds of parts and several


How do you decide which ones to remove?

I was wondering if there was


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.

 

[dan dungan]

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.