Forum Discussion

golf_bears's avatar
golf_bears
Explorer
May 20, 2016

Windows 10 and Excel Spreadsheets????

I'm now on Windows 10 and trying to figure out a problem with Microsoft Excel spreadsheets. Everything was working fine last week. Now a problem has shown up, here's what is happening.

I put a number in cell A then a second number in cell B. Then in cell C I use the Sum function and add cell A and cell B with the result in cell C. Then I change the number in either cell A or B and hit enter. When hitting enter you would expect the sum in cell C to change and reflect the number change in either A or B. It does not change????

Anyone else having this problem and if so does anyone know how to fix it???

5 Replies

  • Flapper's avatar
    Flapper
    Explorer
    May 20, 2016
    bwanshoom wrote:
    Not sure what version of Excel you have, but check your settings. On Excel 2010 & 2013:
    File > Options > Formulas > Workbook Calculation > Automatic.

    You can also manually update the formulas by pressing F9.


    Although I've been out of the game for the last 2 years, when I was doing tech support, this was a very common issue, no matter what version of Excel. Bwanshoom gives the correct answer as to how to resolve the problem. Here's a link with a more detailed description/solution for later versions of Office:

    https://www.emagenit.com/Functions/how-to-turn-off-on-excels-calculation-mode.htm

    I always blamed it on users who were a bit click happy - moving a little too fast and accidentally disabling calculation, when they meant to do something else.
  • golf_bears's avatar
    golf_bears
    Explorer
    May 20, 2016
    I've got the 2013 version. I just rebooted my computer and now everything appears to be working. Something was hung up or Microsoft fixed the problem and downloaded the fix automatically.

    Thanks guys appreciate your input.
  • bwanshoom's avatar
    bwanshoom
    Explorer
    May 20, 2016
    Not sure what version of Excel you have, but check your settings. On Excel 2010 & 2013:
    File > Options > Formulas > Workbook Calculation > Automatic.

    You can also manually update the formulas by pressing F9.
  • RoyB's avatar
    RoyB
    Explorer II
    May 20, 2016
    I know this doesn't fix your problem with the OFFiCE 360 but when I got on the WIN 10 bandwagon I refused all of the subscription software they was pushing.

    I was able to use my older MS OFFICE SUITE 2007 with WIN 10 just fine... I am currently only using 2007 MS WORD and OUTLOOK for emails and haven't tried the EXCEL or POWER POINT yet...

    Probably will find out soon haha... My BILL PAYING Calendar is Excel generated and I haven't done the 2016 version of it yet...

    Guess I better check those to see if they are affected by WIN10...

    Roy Ken

About RV Must Haves

Have a product you cannot live without? Share it with the community!8,801 PostsLatest Activity: Jul 05, 2025