Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Mar 2006
    Location
    Philadelphia, PA
    Posts
    30
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Cell References (Microsoft Excel 2003)

    I had a file w/auto filters and used the filters to shortlist the data to the specified information I wanted. Once I had completed deleting rows of data I didn't want, I noticed that the cell refences in one column changed. Why did this happen? I thought all linked cell references were static and the corresponding row wouldn't move.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cell References (Microsoft Excel 2003)

    Welcome to Woody's Lounge!

    What was the formula?

  3. #3
    Lounger
    Join Date
    Mar 2006
    Location
    Philadelphia, PA
    Posts
    30
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Cell References (Microsoft Excel 2003)

    Hello, Hans.

    The formulas in the affected Column had the the worksheet name, cell column and row..i.e....."Input!Bx".
    I've just noticed that all other columns w/cell references simply have the column & row....."Ax".

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Cell References (Microsoft Excel 2003)

    I am not sure what you are indicating the problem is, but i will make a guess.

    The references are linked to the ranges and will change as the cells in the range change.

    If you have a reference (eg) in A1 which references Cell B5:
    =B5

    and you delete row 4 the reference in A1 will become:
    =B4 since the former row 5 is now row 4.

    If you want the reference to always be B5 even when rows get deleted, then you need to use indirect references:
    =Indirect("B5")

    Now even if rows are deleted or inserted it will always reference cell B5.

    If I have misunderstood your problem could you elaborate on what it is?
    Steve

Posting Permissions

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