Pivot table disallows formula range as data source range?

[PATSYS]

Hi all,

I have a named range called Dbase, and it has the below formula:

=INDIRECT("Sheet2!A1:"&SUBSTITUTE(ADDRESS(1,MAX(IFERROR(MATCH("zzzzzzzzzz",Sheet2!15:15),0),IFERROR(MATCH(9999999999,Sheet2!15:15),0)),4),"1","")&MAX(IFERROR(MATCH("zzzzzzzzzz",Sheet2!D:D),0),IFERROR(MATCH(9999999999,Sheet2!D:D),0)))



When I tried to create a pivot, I typed "Dbase" in the table/range but it gives error message "Reference is not valid".

Is that because the pivot does not allow formula range as source data/table?

Thanks in advance.