C
Cell Reference Problem
Hi,
This is what I was trying to do. I have a formula that
will look into another closed file (excel file) and
determined what to do based on that value.
For example:
=IF('C:\Test\[Sheet1.xls]Sheet1'!$B$6='C:\Test\[Sheet1.xls]
Sheet1'!$G$11,0,INT('C:\Test\[Sheet1.xls]Sheet1'!
$G$52+0.5))
The problem is that when file "C:\Test\Sheet1.xls" don't
even exist. It will still retained the value from the
last time. I am expecting that when
file "C:\Test\Sheet1.xls" does not exist. It will give me
#REF! error. Not the value that was there before.
Thank for the help in advance.
This is what I was trying to do. I have a formula that
will look into another closed file (excel file) and
determined what to do based on that value.
For example:
=IF('C:\Test\[Sheet1.xls]Sheet1'!$B$6='C:\Test\[Sheet1.xls]
Sheet1'!$G$11,0,INT('C:\Test\[Sheet1.xls]Sheet1'!
$G$52+0.5))
The problem is that when file "C:\Test\Sheet1.xls" don't
even exist. It will still retained the value from the
last time. I am expecting that when
file "C:\Test\Sheet1.xls" does not exist. It will give me
#REF! error. Not the value that was there before.
Thank for the help in advance.