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.
Bookmarks