Named formula mystery

[juanito]

I have a named formula for dynamic range "_dq" defined as follows:
=OFFSET(qualdata!$A$2;;;COUNTA(qualdata!$A:$A)-1;COUNTA(qualdata!$1:$1))

I am getting #NAME? errors referencing this formula from other worksheets.

If on the 'qualdata' source worksheet, I can type F5 go to, "_dq" and the range is selected. Yet if I type F5 go to, "_dq", from any other worksheet in my workbook, I get a "Reference is not Valid" error.

To add the the mystery, I have another named formula "_d" defined almost identically (the only difference is that it references a different worksheet), and this works perfectly throughout the workbook.

I will be very grateful if anybody can point to the possible source of this error. Thanks.

- juanito

 

[NARAYANK991]

Hi ,

I tried out your named range in a workbook , and I am not facing any problem.

Can you check 2 points ?

Whether calculation is in Automatic mode or Manual mode ?

Whether the scope of the named range is Workbook or any specific Worksheet ?

Narayan

 

[juanito]

Thank you Narayan -
The issue was with the scope, and I have now fixed it.
- juanito