I tried refreshing without that field, I even used an empty data range, so
that there should be no funds listed. I choose to just delete and recreate
the table, it seems to be working better now. Thanks for all the help.

Keith

"Roger Govier" wrote:

Hi

If you drag the Fund field off the PT, then Refresh and drag the field
back, it should flush the cache of fund names.

--
Regards

Roger Govier


"Co9ug9ar" wrote in message
...
I was using this method, however I save the file using an empty data
range,
so the 1 choice that I do want is in the list. What confuses me is
that even
being refreshed on a completely empty data range, there are still
choices on
the PT menus. It makes me think there is some sort of static list of
names
that are saved onto the PT somewhere, is this true? Where could I
find this
list to change it the way I want it?

"sahafi" wrote:

On your pivot table, click on the fund field arrow, and deselect all
the
items, then select the one fund you would like to keep. Next time
when you
close and reopen the table it will only show that one fund.

h.t.h
--
If u change the way u look @ things, the things u look at change.


"Co9ug9ar" wrote:

I have a pivot table on a template file that reads from a section
of data
imported from a separate file upon each opening. This table is
grouped by
Date, Transaction, and Fund. I only want 1 particular fund number
to show in
this table, is there a way to save the table so it will only show
this fund,
and not load in any new funds that it may see?

I tried loading in a data file that contained every possible fund,
refreshing the table selecting only the fund I wanted, and save the
file, but
the next time I open it and load a new data range it shows every
fund.

Thanks,
Keith