Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    New York, New York, USA
    Posts
    170
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula doesn't copy (XP)

    Here's a strange one: I have 2 users in our company that are creating a formula based on relative cell addressing =((a3-a2)/a2) in cell B3. The result is formatted as a percentage. They have numbers in cells A1:A6. The first formula gives the correct result. However, when they try to copy that formula down in column B (either by using the autofil or copying and pasting), the second result [ which would be =((A4-A3)/A3) ], gives the same number as the first result, which is incorrect (of course).

    This scenario works fine on my machine. I get the correct result when I drag the autofil to the new cell.

    Any ideas?

    Thank you.

  2. #2
    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: Formula doesn't copy (XP)

    Do they have manual calculation enabled? <F9> should calculate the number

    Steve

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

    Re: Formula doesn't copy (XP)

    Do they happen to have calculation set to Manual in the Calculation tab of Tools | Options...?

  4. #4
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    New York, New York, USA
    Posts
    170
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula doesn't copy (XP)

    Hans,

    Excellent !!! This was absolutely the answer.

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula doesn't copy (XP)

    Have the users check Tools/Options, Calculation Tab to be sure that Automatic has a tick mark next to it.
    Legare Coleman

Posting Permissions

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