arnab0711
05-25-2012, 04:50 AM
Hi ,
I have this file Kol_dispatch report which has a sheet raw(base data)on the basis of that there is a pivot table in final sheet and other sheets are linked to that pivot sheet.Now the problem I am facing is if I change the base data in raw file the pivot gets changed and since other sheets are linked cellwise,the whole system goes for a mess.I want such a formula/macro to keep the pivot intact.
I have this file Kol_dispatch report which has a sheet raw(base data)on the basis of that there is a pivot table in final sheet and other sheets are linked to that pivot sheet.Now the problem I am facing is if I change the base data in raw file the pivot gets changed and since other sheets are linked cellwise,the whole system goes for a mess.I want such a formula/macro to keep the pivot intact.