Offset Problem

M

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
 
S

swatsp0p

morrida3 said:
=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 :confused:
Click to expand...

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
 
Top