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-05-24T15:32:36+00:00

    I'm on the latest Mac OS 10.11.4 (15E65) and STILL have this problem!!!!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-05-24T16:17:39+00:00

    Jim, I do not get the impression from the press that MS and Apple are at odds these days. They do seem to be collaborating on offerings like Office, which end to end looks like a massive product. I am, however, under the "impression" (more like an obvious observation) that they aren't even addressing issues like this that persist for literally years. MS has written and has been the world leader of this massive office suite of applications for decades on both OS's and they don't have the know-how to fix this auto recalculate problem? Please! They're not even trying.

    As for updating the OS, again, enough people in this thread already do that to stop resorting to that suggestion. How many times do you have to read "I'm already on the latest version...(whether of Mac OS or Excel)... and it still doesn't work" to realize that is not the problem?

    The problem persists because the problemhas not yet even been addressed. I deal with this every day and have dealt with this at every company I've worked for or with. In short, the guys or gals who can fix this are not working on it.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-05-24T16:26:02+00:00

    I think Joe Tunon has it nailed just about right. It's not troubling enough to the management of MS to assign resources to fix this. I think the best hope is that there is a more major bug that gets fix and has a side effect of fixing this one.

    Was this answer helpful?

    0 comments