Is there a value in every cell in the used range in column A?
If there are only 487 entries in that column, that's how many rows the
dynamic range will have.

Wanna Learn wrote:
Hello I have a named ranged and in the refer to is this formula
=OFFSET(Pivot!$A$1,0,0,COUNTA(Pivot!$A:$A),COUNTA( Pivot!$1:$1))
the problem is that it stops at rows 487 so everything ater row 487 is not
included in the pivot table ? what's wrong with the formula?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html