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: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2016-04-26T03:45:57+00:00

    Still not fixed indeed.  An update though, i spent some hours on the phone with Microsoft a week or two back, and eventually worked my way up to someone high enough who was willing to look at the problem in more detail and logged in remotely and saw the issue replicated dozens of times.  He seemed to want to keep going until he found that it worked correctly occasionally and i felt like he was trying to say that since it occasionally worked, that it was not a problem.  I didn't accept that and the final result is that our office is now all upgraded/downgraded to Office 2011 which works fine.

    I'm surprised, but this is the current working solution from Microsoft.  I was given the following link to download the latest version and we installed that on all workstations and then transferred the Open With... details for .xls and .xlsx files to use the older version of Excel.

    http://officecdn.microsoft.com/pr/MacOffice2011/en-us/MicrosoftOffice2011.dmg

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-05-24T12:04:40+00:00

    A change to the operating system to fix a spreadsheet refreshing its calculations?

    That's even better than telling people to upgrade to the latest version of Office, as if we're not already doing that, waiting for this ridiculous problem to be fixed.

    Was this answer helpful?

    0 comments
  3. Jim G 134K Reputation points MVP
    2016-05-24T15:25:58+00:00

    You might get the impression from the press that Microsoft and Apple are at odds about everything, but they actually work together closely to ensure Office for Mac works correctly. 

    Updating Mac OS when you update office apps is a good way to ensure you have the least amount of trouble.

    Was this answer helpful?

    0 comments