I am trying to setup an external reference using the offset function, as
in:

=OFFSET('\\file_path\[filename.xls]worksheet'!$CR$20,0,0)

Ultimately this will help me creating copies of this and many other
external references where data will accumulate in predictable ways.
The problem is, the formula as shown returns a #VALUE error.

The function will work if the file is currently open, but after I close
the file (and then refresh the formula calcs) the error returns.

Any idea what I'm doing wrong?


--
AndrewPace
------------------------------------------------------------------------
AndrewPace's Profile: http://www.excelforum.com/member.php...o&userid=33417
View this thread: http://www.excelforum.com/showthread...hreadid=532354