Offset Problem

[morrida3]

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

This formula linked to another spreadsheet previously worked, but a ne
workbook has been created and the formula now returns a "0" value to th
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

 

[swatsp0p]

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

This formula linked to another spreadsheet previously worked, but a ne
workbook has been created and the formula now returns a "0" value to th
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

It looks in your post as if you are using the 'accent' mark -- `-- t
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 i
not open, you should list the complete path to the file:
=OFFSET(`C:\My Documents\Excel\[worksheet05.xls]PROCES
LOG`!$K$9,B9-4,0,1,1) or similar.

Good Luck