Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Apr 2001
    Posts
    482
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am trying to put in a relative reference to a cell in another worksheet. However, every time I remove the path to just keep the file name, Excel puts it back. Same if I try to put ".\".

    A sample of the formula is:

    =ROUNDUP('C:\Documents and Settings\xxxxxxxx\My Documents\[File.xls]2005'!G7300,2)

    How can I make this reference something like:

    =ROUNDUP('[File.xls]2005'!G7300,2)

    since the file is in the same directory?

    Thanks!!
    Troy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    As long as the other workbook is open, Excel will only display the workbook name in the formula.
    As soon as you close the other workbook, Excel will display the absolute path in the formula. You can't prevent this.
    But if you move both the workbook with the formulas AND the workbook the formulas refer to to another folder, the formulas will be adjusted automatically when you open the workbook. So you don't really need to worry about it.

Posting Permissions

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