Hello,
Im using Excel 2000. Im 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 cant
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.