+ Reply to Thread
Results 1 to 6 of 6

Excel 2011 Does Not Copy Cell Formulas Properly

  1. #1
    Registered User
    Join Date
    07-05-2011
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2011
    Posts
    3

    Excel 2011 Does Not Copy Cell Formulas Properly

    Hi.

    I have several columns of data and I would like to take the average of each of these columns separately.

    First, I do AVERAGE() on the first column and get the correct number

    Next, I drag the value in that cell across the remaining columns of which I want to take the average.

    Excel does this, but keeps the original value for the first cell in each instance! I check the formulas and they are correct - when I delete and re-enter the last parenthesis ")" the formula refreshes to its correct value.

    This is bothering me a ton, as I wonder what other calculations my Excel is messing up.

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Excel 2011 Does Not Copy Cell Formulas Properly

    Hi,

    Try:

    Tools - Options.
    Go to the Calculation tab and set Calculation to Automatic instead of Manual.

    Article

    Cheers,
    Last edited by ConneXionLost; 07-05-2011 at 11:42 AM. Reason: Added link
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Registered User
    Join Date
    07-05-2011
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2011
    Posts
    3

    Re: Excel 2011 Does Not Copy Cell Formulas Properly

    Thanks - I went into preferences (mac) --> calculation and "Automatically Calculate" is already checked. It's odd because I had this problem with Excel 2008 as well.

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Excel 2011 Does Not Copy Cell Formulas Properly

    Did you check the Calculation state with that workbook open?
    Remember what the dormouse said
    Feed your head

  5. #5
    Registered User
    Join Date
    07-05-2011
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2011
    Posts
    3

    Re: Excel 2011 Does Not Copy Cell Formulas Properly

    Yes - That workbook is open.

  6. #6
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Excel 2011 Does Not Copy Cell Formulas Properly

    Is it only that workbook, or all workbooks?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1