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-19T10:20:56+00:00

    Mikko,

    Having followed the thread, maintaining a respectful silence in the company of my more knowledgeable peers, I believe that the consensus has indeed identified a Refresh issue (on any Mac) rather than failure to Recalculate. At least we now know that performing extra (and annoying) refresh key strokes such as cmd-R and/or scrolling the screen onto and off the offending cells will deliver the required result.

    Microsoft frequently churn out large updates that I download and install with increasing disillusionment as whatever bugs they are attempting to resolve, the Refresh issue is never one of them.

    The option of importing Excel spreadsheets into Apple Numbers is not without problems because of the formatting differences etc. I guess that Microsoft know that and are confident that MAC users won't bother to convert. They are wrong as far as I am concerned because I can't afford the risks associated with the unreliability of Excel's performance on the Macs in my business where I need to make frequent visual reference to financial positions on screen.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-07-18T23:10:39+00:00

    Can confirm that it's a refresh issue rather than basic maths.  I think we touched on that earlier in this forum.

    Might be interesting to see if it's related to a specific graphics card perhaps?

    This is what i have on a 27inch iMac.

    NVIDIA GeForce GTX 780M 4096 MB

    Having said that now, we have the same issue in our office on all 5 of our iMacs which are all of different ages and models and sizes and with different OSX versions as well as on my laptop which is a MacBook Pro from late 2012.

    Doesn't sound specific to a particular component really, and we have both Intel based iMacs as well as one older one somewhere which i haven't checked out specifically.

    Not sure if that helps.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-07-18T17:36:47+00:00

    So again, you're saying that I should subject myself to unsupported, possibly bug laden, builds just so I can discuss an issue with a production build that has existed for 13+ months?  Does that actually make good business sense?

    Are you a Fast Track member?  If so, can you bring this issue up on the forum on all our behalves?

    Anyway, after much experimentation, I have it narrowed down to a display refresh issue, not a recalculation issue.  The offscreen cells actually do recalculate properly, they just don't look like they did once scrolled back into view.  

    For example:

    A1=10

    A2=20

    B99 (off screen) = A1+A2 --- initially shows 30 as expected.

    B2=B99 --- also shows 30 as expected.

    Change A2=40

    B2 now shows 50 as expected, however if you scroll down to B99 it still shows 30.

    Now if I zoom the view in and out again (using the zoom slider bottom right) B99 display will refresh and correctly display 50.

    So, I am thinking is this is more of a display issue than a recalculation issue.  Perhaps the way Excel interacts with the video driver on some Macs?

    Anthony

    Was this answer helpful?

    0 comments