Pivot table source data goes from dynamic - using indirect() - to static range

[BrandonAS]

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.

 

[tjdurkin]

Hi Brandon, This isnt a PowerPivot question. You may get more responses posting in Excel Questions.

 

[BrandonAS]

OK. Thank you. Will do.