+ Reply to Thread
Results 1 to 2 of 2

Offset Problem

  1. #1
    Registered User
    Join Date
    09-15-2005
    Location
    UK
    Posts
    1

    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 data value is (eg) 123 yet the link returns 0.

    Any help or advice will be appreciated.

    Thanks
    Last edited by morrida3; 09-15-2005 at 08:44 AM.

  2. #2
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    Quote Originally Posted by morrida3
    =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
    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.
    Bruce
    The older I get, the better I used to be.
    USA

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1