Marcster
04-18-2009, 05:06 AM
Hi People,
Can a PivotTable's Datasource be updated from the contents of a cell?.
For instance, I have a PivotTable on Sheet Analysis named PivotDATA
with it's current DataSource as DATA!R2C1:R355.
This DataSource value I've typed into cell D1 on the PivotTable sheet Analysis.
If I change this cell, D1 to a new datasource, can the PivotTable use this and refresh the Pivottable?.
Thanks,
Can a PivotTable's Datasource be updated from the contents of a cell?.
For instance, I have a PivotTable on Sheet Analysis named PivotDATA
with it's current DataSource as DATA!R2C1:R355.
This DataSource value I've typed into cell D1 on the PivotTable sheet Analysis.
If I change this cell, D1 to a new datasource, can the PivotTable use this and refresh the Pivottable?.
Thanks,