Excel 2007 pivot table range problem. My source data range goes from dynamic to static.
I've simplified the problem to just the core and here it is:
Data is a 3x2 range in cells A1:B3.
Reference to data range in cell E4. E4 contains text: A1:B3
I reference the range using the indirect function =indirect(E4) to get the source data range for a pivot table and it works. However, when I look in the pivot table source data range it has retained the static range: Sheet1!$A$1:$B$3, not the indirect function: =indirect(E4). Why is it not retaining the formula?.
</SPAN>
I am using Excel 2007 and all in the workbook is built in 2007. (not from previous versions of Excel or previous pivot table versions).
Thank you in advance for your help.
I've simplified the problem to just the core and here it is:
Data is a 3x2 range in cells A1:B3.
Reference to data range in cell E4. E4 contains text: A1:B3
I reference the range using the indirect function =indirect(E4) to get the source data range for a pivot table and it works. However, when I look in the pivot table source data range it has retained the static range: Sheet1!$A$1:$B$3, not the indirect function: =indirect(E4). Why is it not retaining the formula?.
</SPAN>
I am using Excel 2007 and all in the workbook is built in 2007. (not from previous versions of Excel or previous pivot table versions).
Thank you in advance for your help.
