Excel 2016 for Mac does not recalculate

Anonymous
2015-08-01T00:09:35+00:00

I have a multiple-sheet workbook that does not recalculate after I update some cells. It would only recalculate after I save and then reopen it. My Excel preferences is set to automatic recalculate. After I change the value of cells, the workbook does not recalculate even after I press the F9 key. I have tried Command+F9 to no avail. The workbook had a data connection and I had deleted it. The version is 15.12.3. Any idea what I can do?

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2017-07-09T08:51:04+00:00

ref my earlier question I found an answer that worked:

Why does my formula not calculate in Excel?

Instead the text of the formula itself appears in the cell directly. See example below. Cause: The cell is formatted as Text, which causes Excel to ignore any formulas. This could be directly due to the Text format, or is particularly common when importing data from a CSV or Notepad file

I copied the data from the original import worksheet into a fresh worksheet and the formulas worked fine

Was this answer helpful?

3 people found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2016-09-15T18:53:52+00:00

As Anthony noted, version 15.26 (160903) does contain the fix. This version has now been released to all audiences. Please make sure your Office is up to date and this problem should be resolved.

Thank you all for your patience and persistence!

Freya

Office Newsroom

Was this answer helpful?

0 comments

112 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP
    2016-07-06T14:21:54+00:00

    It's clear that switching the View works for some, but not all users. 

    The Smile submissions go directly to the program managers. Even though that communication is one-way, be assured your submissions are going to the right place.

    That $499 gives you access to a support specialist who probably knows little about Excel for Mac. You were wise to skip that.

    There's a way you can interact directly with Excel developers for free, but it comes with many caveats. You can join the Insider Fast program and use beta software. It is not supported at all even if you pay the $499, but you do get a direct channel to interact with Microsoft developers in a special Insider forum. The goal of the Fast program is to give Microsoft user feedback on new features, updates, bug fixes etc before they are released to everyone in a general release. The builds sometimes will have new features, incomplete features, bug fixes, experiments in user interface - in other words you're getting a build that could be the future - or maybe not. The builds are larger and more frequent than regular updates. If you don't mind using builds that are generally good, sometimes outstanding with new features no one knows about, and occasionally messed up or broken in unexpected ways, then go to the Excel Help menu and choose Check for Updates. In AutoUpdate check the box to join the Insider program and then choose the Fast option. If you just want to get the supported general releases ASAP join the Insider Slow program.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-07-05T18:04:23+00:00

    Agree, view mode does not matter.  Except perhaps changing views also happens to change what cells are In the visible view pane.  As described several times, only cells outside the visible view are affected.   

    And for reference, I've sent close to 20 messages via the smile/frown face, one for every version this bug existed in for the past year, all to no avail.   That smile feature is useless.  And worse, he. I tried to open an actual case with MS support I was told I'd have to pay $499 to take to a specialist.  

    What a joke.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-07-05T16:37:28+00:00

    Switching to Normal view has fixed the problem for others, as well. Please give it a try.

    Be sure to let Microsoft know about the problem in the current update by using the Smile button in Excel.

    Thanks for your suggestion Jim but regrettably I found that the View (Normal or Layout) made no difference to the auto-calculation. Some cells with formulae would auto-calculate whilst others didn't unless I either scrolled the screen around a couple of times so that the miscreant formulae cells became visible and then went off screen (this seems to trigger the calculate), or I pressed cmd-R. The latter was the quickest and most reliable technique but this should not be a necessary extra step to have to take. BTW the problem started with Office 360; previous versions of Excel worked fine on Mac.

    I have now sent a message to MS via the Smile button in Excel!

    Was this answer helpful?

    0 comments