BBM
11-17-2009, 02:50 AM
HI All,
I want to create a data connection which I will use for a pivot table.
THis is fine if I want a static SP with no parameters, but I would like to be able to specify a parameter (a year, e.g. int 2009) and bind its value to a cell on a sheet.
I'm using Excel 2007 btw.
Is this possible? I cant see how!
Thanks,
BBM
I want to create a data connection which I will use for a pivot table.
THis is fine if I want a static SP with no parameters, but I would like to be able to specify a parameter (a year, e.g. int 2009) and bind its value to a cell on a sheet.
I'm using Excel 2007 btw.
Is this possible? I cant see how!
Thanks,
BBM