Define Dynamic Range prob, searched.

I need to define a dynamic range for a Pivot Chart. I've read several "How-To" and came across the write formula to use. My range consists of the entire table on my sheet "data" from A1 to F390. This data will be updated every quarter so I need my pivot table's range to be updated with it.

I'm using excell 2000. The data contains numbers and letters, depending on the column

Problem: I go to Insert>Name, name the range "Data" and type"
=OFFSET(data!$A$1,0,0,COUNTA(data1!$A:$A),COUNTA(data!$1:$1))

I get an error saying the formula I typed contains and errror etc. When I click OK, =OFFSET(data!$A$1,0,0,COUNTA(data1!$A:$A),COUNTA(data!$1:$1)) The red text is highlighted.

I've tried many time to change things. I also tried it with just a 1 at the end to remove the dynamic count of column number. There aren't any empty cells. I searched to find nothing remotely close. This seems to normally be a pretty routine function, what am I missing?

Thanks for the help

No I don't have a data1, I typed copied it to the thread improperly. It is just "data" in the spreadsheet.

The exact error reads:
"The formula you typed contains an error.
- For information about fixing common formula problems, click help.
- to get assistance in entering functions, click OK, then click Function on the insert menu.
- If you are not trying to enter a formual, avoid using an equal sign or minus sign or precede it with a single quotation mark."

To clarify, the exact formula I tpyed is. "=OFFSET(data!$A$1,0,0,COUNTA(data!$A:$A),1)"

just one sheet named "data"

thanks for the quick replies.

Well, If it works for you, and I copy and pasted it right out of the refers to box, it should be syntactically correct, at least I would reason to believe.

The only thing I can think of is that the computer I'm on has a different keyboard, uk maybe, from a French company, so the software could be different and somewhere between the keyboard and the software translating to english it gets jumbled? I dunno, just a wild guess.

The data is pretty sensative so I can't post it ufortunately. Are there any other conditions that need to be fulfilled with the data or the table for this to work properly.

Originally Posted by NBVC

Try replacing all the commas with semicolons...

Genius!! I don't know why but that worked. Thank you!