Hi,

I really want to be able to change the values in my pivot table 'driver' cells by referencing another cell (I have my pivot table on sheet 1, and want to alter it on sheet 2 as that is where all my graphs are). I want to be able to show Jan data, then feb, mar etc through a drop down box on sheet 2 and then make the data update to the appropriate month according to what is selected, I just cannot work out how to alter the pivot table through referencing? I know I could do this through VB, but would prefer not to.

Any help greatly appreciated.

Thanks,

Addal.