Offset Problem
 

=OFFSET(`[worksheet05.xls]PROCESS LOG`!$K$9,B9-4,0,1,1)

This formula linked to another spreadsheet previously worked, but a new
workbook has been created and the formula now returns a "0" value to the
cells?

No errors etc are shown with the formula. The source date value is (eg)
123 yet the link returns 0.

Any help or advice will be appreciated.

Thanks :confused:


--
morrida3
------------------------------------------------------------------------
morrida3's Profile: http://www.excelforum.com/member.php...o&userid=27269
View this thread: http://www.excelforum.com/showthread...hreadid=467781

morrida3 Wrote:
=OFFSET(`[worksheet05.xls]PROCESS LOG`!$K$9,B9-4,0,1,1)

This formula linked to another spreadsheet previously worked, but a new
workbook has been created and the formula now returns a "0" value to the
cells?

No errors etc are shown with the formula. The source data value is (eg)
123 yet the link returns 0.

Any help or advice will be appreciated.

Thanks :confused:

It looks in your post as if you are using the 'accent' mark -- `-- to
set off the file name. It should be a single quote (apostrophe) -- '
-- . Small difference, big problem!

One other thing to look at is the location of the file. If the file is
not open, you should list the complete path to the file:
=OFFSET(`C:\My Documents\Excel\[worksheet05.xls]PROCESS
LOG`!$K$9,B9-4,0,1,1) or similar.

Good Luck.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=467781