copied formulas on Excel the value doesn't change

Discussion in 'Microsoft Excel Worksheet Functions' started by Guest, Nov 27, 2006.

  1. Guest

    Guest Guest

    When i copied formulas from D1 through D6, why is it that D2 to D6 valve is
    the same as D1? But the cell refects the correct formulas.

    A B C D
    1 122 455 577
    2 528 45 577
    3 3214 12 577
    4 980 12444 577
    5 154 87 577
    6 31274 855 577
     
    Guest, Nov 27, 2006
    #1
    1. Advertisements

  2. Guest

    Guest Guest

    D1 =B1+C1
    copy from D1 to D6


    "Jane" wrote:

    > When i copied formulas from D1 through D6, why is it that D2 to D6 valve is
    > the same as D1? But the cell refects the correct formulas.
    >
    > A B C D
    > 1 122 455 577
    > 2 528 45 577
    > 3 3214 12 577
    > 4 980 12444 577
    > 5 154 87 577
    > 6 31274 855 577
    >
     
    Guest, Nov 27, 2006
    #2
    1. Advertisements

  3. Guest

    Guest Guest

    > When i copied formulas from D1 through D6,
    > why is it that D2 to D6 value is the same as D1?


    The calc mode may be inadvertently set to Manual. Press F9, does it now
    compute properly? To check/change calc mode: Click Tools > Options >
    Calculation tab. Options are there. Ensure "Automatic" is checked > OK.
    --
    Max
    Singapore
    http://savefile.com/projects/236895
    xdemechanik
    ---
    "Jane" wrote:
    > When i copied formulas from D1 through D6, why is it that D2 to D6 valve is
    > the same as D1? But the cell refects the correct formulas.
    >
    > A B C D
    > 1 122 455 577
    > 2 528 45 577
    > 3 3214 12 577
    > 4 980 12444 577
    > 5 154 87 577
    > 6 31274 855 577
    >
     
    Guest, Nov 27, 2006
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. JJ

    Copied formulas paste as text and paste special does not work

    JJ, Sep 14, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    290
  2. Guest

    Can't work formulas in sheets copied from the web

    Guest, May 1, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    139
    Gord Dibben
    May 2, 2004
  3. RickyDee

    Can't work formulas in sheets copied from the net

    RickyDee, May 2, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    176
    Guest
    Jul 1, 2004
  4. Guest

    change cell value greater than another cell value using formulas

    Guest, Apr 2, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    398
    Bill Kuunders
    Apr 2, 2006
  5. Guest

    making copied cells change with change in original cell

    Guest, Jul 20, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    149
    Maistrye
    Jul 20, 2006
Loading...

Share This Page