Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Dec 2007
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have an Excel file and I wanted to create another Excel file for a different department but only want certain information to be linked between the file. I've been manually linking one cell (this = to this) at a time because Excel would not allow me to copy and drag down the formula. Does anyone know why? Is this something unique to the 2007 version.

    Thank you.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    By default, Excel will create an absolute reference when you refer to a cell in another workbook, e.g.

    =[OtherWorkbook.xls]Sheet1!$A$1

    The $ characters make the reference to A1 absolute, which means that it won't change if you fill down or to the right. To make the reference relative, remove the $ characters:

    =[OtherWorkbook.xls]Sheet1!A1

    The formula will now adjust itself if you fill down or to the right.

  3. #3
    Star Lounger
    Join Date
    Dec 2007
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts
    oh my goodness..I feel stupid. Danke Hans!

Posting Permissions

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