Thread: Pivot Table - Few complicated queries

Dear Friends & Gurus, Best wishes!

I am facing a couple of problems with pivot table (Excel 2007).

I created a pivot table with A1:DA1000.

1) I tested with few sample data (filtering with required values, etc). When test is over, then I deleted the sample data in the source mentioned above and entered the original data. Eventually when I refreshed the Pivot table, still the old values (the sample data tested) are appearing (in the label filters) and these unneccessary values are not deleted. It is very much annoying. How to get rid of this? I unchecked the Pivot Table Options > Data > Save source data with file also. But no relief.

2) How to select only selected columns for pivot table? I have data in A1:DA1000. I need a pivot table for 4 columns only (A, F, BB, DA). How to choose only these 4 columns for pivot table?

3) Is there any way to get entire pivot table values (after filtering) in another sheet? i.e. with the above range I created a pivot table. Then I filtered with few values. Now I need only these filtered values in another sheet as it is. Is there any possiblity to get these values by referring the pivot table name? So that whenever pivot table is refreshed the required values will appear in other sheet also. (I tried with GETPIVOTDATA, but we need to refer each and every column and value).

As always, I seek your kind suggestions and solutions for the above.

Thanks in advance.

acsishere.

Best wishes to all!

Any help / suggestion to the above query. I hope someone will come up with a solution.

Thanks in advance.

acsishere.

1. to remove the old entries from the filter.. remove that field from the pivott table.. refresh ur pivot table and then add the field again.. the old values that dont exist anymore shud disappear.

2. what difference does it make.. make the pivot table with all the data and then only add those columns in the pivottable... or am i not understanding the question..

3.. try making a pivot table based on another pivot table ?
would help if there was a sample file

hope dat helps a lil

For your third question, you can copy and paste special the data from your filtered pivot table to another location. That is, if you don't need to filter the data again. Otherwise, create another pivot table in another location and filter that one separately. As useful as pivot tables are, they don't conform to all the possible transformations that Excel users dream up.