I made a pivot table with dynamic range and below is my offset function
the name is defined "finacialoffset"
the worksheet name is " financial"
the number of column is 6

=OFFSET(finanancial!$A$1,0,0,COUNTA(financial!$A:$ A),6)

BUT I have error as above! when I put this name in wizard

Any comment are welcome

Thanks
Daniel