G
Guest
Hello,
I’m using Excel 2000. I’m trying to name a range for a dynamic formula to
be used in a pivot table. I found a very good tip on this site, but I can’t
get the “named range†to work. Here is what I've done:
I name the range by choosing Insert > Name > Define
I type my name “RRBB001†without the quotes.
In the Refers to box I type
=offset(data!$A$1,0,0,Counta(Data!$A:$A),7)
I click OK
Then a choose the pivot table and for the range I type “RRBB001â€, click Next
Here is where I get the error message “ Reference is not validâ€
However, when I go back into Insert > Name > Paste, the name prints and the
offset formula. Help is appreciated as always.
I’m using Excel 2000. I’m trying to name a range for a dynamic formula to
be used in a pivot table. I found a very good tip on this site, but I can’t
get the “named range†to work. Here is what I've done:
I name the range by choosing Insert > Name > Define
I type my name “RRBB001†without the quotes.
In the Refers to box I type
=offset(data!$A$1,0,0,Counta(Data!$A:$A),7)
I click OK
Then a choose the pivot table and for the range I type “RRBB001â€, click Next
Here is where I get the error message “ Reference is not validâ€
However, when I go back into Insert > Name > Paste, the name prints and the
offset formula. Help is appreciated as always.