G
Guest
Why would I be getting a #value on this formula
="'[adc.xls]"&B10&"'!$b$27"
="'[adc.xls]"&B10&"'!$b$27"
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
Remove the checkmark under tools>options>transition "transition formula
valuation"
valuation"
B
Bob Phillips
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)
=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)
G
Guest
Peo, what is the purpose of this checkmark (flag) or is used for?
Peo Sjoblom said:Remove the checkmark under tools>options>transition "transition formula
valuation"
--
Regards,
Peo Sjoblom
Libby said:Why would I be getting a #value on this formula
="'[adc.xls]"&B10&"'!$b$27"
P
Peo Sjoblom
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
believe
Some people who are used to Lotus use it
It's a nuisance to me
--
Regards,
Peo Sjoblom
rob said:Peo, what is the purpose of this checkmark (flag) or is used for?
Peo Sjoblom said:Remove the checkmark under tools>options>transition "transition formula
valuation"
--
Regards,
Peo Sjoblom
Libby said:Why would I be getting a #value on this formula
="'[adc.xls]"&B10&"'!$b$27"
G
Guest
That was it. Gosh you are so smart. Thanks!
--
Libby
--
Libby
Peo Sjoblom said:Remove the checkmark under tools>options>transition "transition formula
valuation"
--
Regards,
Peo Sjoblom
Libby said:Why would I be getting a #value on this formula
="'[adc.xls]"&B10&"'!$b$27"