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?

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.

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.

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.