Why would I be getting a #value on this formula

="'[adc.xls]"&B10&"'!$b$27"

--
Libby

Remove the checkmark under toolsoptionstransition "transition formula
valuation"



--
Regards,

Peo Sjoblom


"Libby" wrote in message
...
Why would I be getting a #value on this formula

="'[adc.xls]"&B10&"'!$b$27"

--
Libby

Try

=INDIRECT("'[adc.xls]"&B10&"'!$b$27")

but it will fail if you close adc.xls


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Libby" wrote in message
...
Why would I be getting a #value on this formula

="'[adc.xls]"&B10&"'!$b$27"

--
Libby

Peo, what is the purpose of this checkmark (flag) or is used for?



"Peo Sjoblom" wrote:

Remove the checkmark under toolsoptionstransition "transition formula
valuation"



--
Regards,

Peo Sjoblom


"Libby" wrote in message
...
Why would I be getting a #value on this formula

="'[adc.xls]"&B10&"'!$b$27"

--
Libby

If a spreadsheet is imported from Lotus 123 it will check automatically I
believe
Some people who are used to Lotus use it
It's a nuisance to me


--
Regards,

Peo Sjoblom

"rob" wrote in message
...
Peo, what is the purpose of this checkmark (flag) or is used for?



"Peo Sjoblom" wrote:

Remove the checkmark under toolsoptionstransition "transition formula
valuation"



--
Regards,

Peo Sjoblom


"Libby" wrote in message
...
Why would I be getting a #value on this formula

="'[adc.xls]"&B10&"'!$b$27"

--
Libby

That was it. Gosh you are so smart. Thanks!
--
Libby


"Peo Sjoblom" wrote:

Remove the checkmark under toolsoptionstransition "transition formula
valuation"



--
Regards,

Peo Sjoblom


"Libby" wrote in message
...
Why would I be getting a #value on this formula

="'[adc.xls]"&B10&"'!$b$27"

--
Libby