#REF! does not show

[JL]

Hi,

I am having problem when a sheet that is refering another
file. If the file does not exist. I am expecting
a "#REF!" to show and it does not. I did some research
and they said something about a link reference file. I
was wondering how does it work.

Any help to pointing me to right direction is very much
appreciated.

Thank you in advance.

 

[Norman Harker]

Hi JL!

Maybe more help will be forthcoming if you:

Give example of your formula that is referring to another file.

Say what it is returning?

Where, exactly is the requested file located.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Tuesday 5th August 2003: Burkina Faso
(Independence Day), Croatia (Homeland Thanksgiving Day), Dominican
Republic (Santo Domingo Foundation Day), El Salvador (Transfiguration
San Salvador del Mundo), Peru (Virgen de las Nieves), Tuvalu (National
Children's Day). Observances: Hiroshima Day (23:15 UST 1945)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.