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: Newest
Most helpful Newest Oldest
  1. Anonymous
    2016-07-23T19:09:14+00:00

    I am not aware to have received any private message nor do I know where I should look for them. Just post what you have to say to me here - after all this is what you do in forums..

    Stephan

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-07-23T18:32:43+00:00

    Hi Freya

    I have version 15.24 for mac and I still have this problem. Have you identified the bug fix yet?  Super annoying to use excel in mac for this reason.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-07-23T16:16:29+00:00

    Dear Freya,

    Thanks for taking an interest in this issue.

    Regarding your question about the Auto Recalc option, this was of course the first thing that I checked. I have never disabled the default which is Autorecalculate.

    I do not use more than one display per Mac computer.

    The failure to recalc issue started since Office 2016 was installed. Workbooks generated on previous versions of Excel recalulated perfectly but now do not. Similarly, new Workbooks created in Excel 2016 do not recalculate.

    More detail as follows:

    If the cell containing the formula is visible on screen at the same time as the data entry cell, then the formula will usually recalculate. If the formula cell is not visible ( i.e. off screen) then it will not recalculate (ie update) until viewing it then scrolling it off screen, then scrolling back in to view on screen. The alternative method is to hit cmd-R which seems to trigger the refresh/recalculation.

    The above has been my experience but other users may have had different experiences.

    Robert

    Was this answer helpful?

    0 comments