Pivot Table

[CONFUSED_AS_USUAL]

Hi Guys,

A few questions.

I have a pivot table currently pointing to a very larger and ever growing worksheet that is currently over 500,000 lines long and a bit over 100 megs in size. It works well - does the job, but of course it is clunky. I refresh & work with this daily.

1. How do I make create a pivot table that is pointing to the data source (that will be closed) without having the burden of it still being a huge file in the background ?

2. I tried the "DATA-GET DATA- FROM FILE-FROM WORKBOOK" method. The pivot table file ends up still being as big. No diff.

3. Unrelated question, but my particular pivot table points to an "Item Code" field. I use the item code field as one of the filters in the pivot table. I have 67,000 active item codes. Each time I want to search by the item code, it seems to take the first occurrence of the partial code.
I want it to filter ONLY item number 3712. However, there are many instances where this is number is PART of another number. Example ABC3712. How can I do it to filter exactly the number in question ?

Thanks.

 

[Chrisdontm]

Re: Pivot Table - Help Needed

PART 2:

When you set the filter there is a custom sort called: " NUMBER FILTERS "

Use that to have it filter the exact number you want.

 

[CONFUSED_AS_USUAL]

Re: Pivot Table - Help Needed

PART 2:

When you set the filter there is a custom sort called: " NUMBER FILTERS "

Use that to have it filter the exact number you want.

Sorry - no luck. Perhaps you could send me a small sample to illustrate ?

Thanks

 

[sandy666]

Re: Pivot Table - Help Needed

post an representative example of your data and expected result or better, link to shared excel file with this example.
of course good detailed description will be a good addition