Offset Problem

  • Thread starter Thread starter morrida3
  • Start date Start date
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
 
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
 
Back
Top