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. Anonymous
    2016-07-07T12:37:37+00:00

    Unfreezing panes does not change anything for me. I have the same issue. Recalc is on but the spreadsheet does not recalc. Actually by pressing F9 it recalculates (visible at the bottom of the Excel window) but the cell values doe not change!!

    Only when going directly in the cell values and hitting return do they change.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-07-07T12:31:29+00:00

    I have the same problem. The Excel breaks. There is no way to recalculate it but by recalculating every cell hitting enter. The recalculation button does not work. Neither does F9 (or FN + F9). 

    The spreadsheet is broken. Fullstop.

    To the ignorant MS service guys: Yes, I do have automatic calculations switched on. This is not the problem.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-07-06T15:49:19+00:00

    Hi Jim,

    Thanks for the reply - my cynicism on the smile interface comes from the fact that this bug has been reported via that smile 20+ times from just me, and probably 100s if not 1000s of times from the user base in mass.  However, the bug remains even after over a year of those reports.  So, while they may be going to program managers, they are apparently not getting to anyone who can actually resolve the issue, so in that case I say they are not getting to the right place.  

    What's more frustrating is that if you do a Google search, this bug has been reported on this forum on at least 6 different threads in addition to this one, again for over a year, and still no resolution.  I understand this is a user-user forum, but if no one from MS ever checks in, then it's not helping.

    Now you're telling me if I had a spare Mac I could join the fast program and possibly interact with a MS developer.  Unfortunately I don't have a spare Mac and I can't risk beta software on my day to day Mac.

    So perhaps you can be the champion of all the frustrated users that have been struggling with this bug for several months... as an MS MVP, you can join the "fast" program and report this bug for us.

    Anthony

    Was this answer helpful?

    0 comments