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-09-26T22:56:09+00:00

    Hi Freya,

    This fix does seem to have fixed the calculation issue, however it has also brought back previous issues to do with cells freezing and also with Page Orientation.

    On screen now, from time to time, the highlighted cell is not located correctly. That is to say that the green cell highlight appears about three of four rows higher than it actually is (sometimes appearing across two cells), making it very difficult to locate the cell your trying to edit.  This issue was fixed last year in one of the earlier updates.  This is sporadic, and only occurs some of the time.  There seems to be an occasional lag issue as well with the cell highlight moving well after it is moved with the arrows.

    Also, and more notably, the Page Orientation is again no longer worksheet specific.  When printing an "Entire Workbook", the page orientation of all worksheets seems to revert to the last saved orientation of any of those worksheets. Meaning that you can't print out one worksheet in Portrait, the next in Landscape etc.  They all print out the same.  This issue was also fixed on an earlier update, but has now reappeared for some reason. Are they linked somehow?

    Mikko

    Was this answer helpful?

    0 comments
  2. Jim G 134K Reputation points MVP
    2016-09-27T14:53:11+00:00

    When discussing updates, keep in mind there are always at least 3 current updates in circulation. Go to the Excel menu and choose About Excel and include the version and build number with your reply. Every week there could be a new build, and not everyone gets them at the same time, so it's important to know exactly which build you are talking about.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-09-28T02:28:56+00:00

    Apologies, i'm now up to date as far as 15.26 (160910).

    If it helps, i'm running this on OSX El Capitan 10.11.6.

    Was this answer helpful?

    0 comments