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
    2015-12-02T22:36:32+00:00

    Hi Jim,

    Thanks for that. You are a little late in responding, and i can confirm that Excel is routinely updated along with our other Microsoft products, and has since been updated to the now current version 15.16 (151105).  We're also on Mac OS X here which is presently at 10.10.5.  We haven't updated to the recent El Capitan as yet, as things tend to go haywire with brand new updates.

    I can also confirm that this calculation error is still occurring if the total field is outside of the immediate view of the window.  When a change is made to the list of sum fields, and you scroll down to see the total, it is unchanged.  I've noticed that if i switch (Command-Tab) to another program and come back to the excel window with the sum field in view, it also updates to the correct sum as the switch happens.

    Appreciate anything you might have to offer.  I'm hopeful with every new update, but i still find it a little unbelievable that a spreadsheet can't add up a simple sum of 20 or so numbers correctly.

    Regards,

    Mikko

    Was this answer helpful?

    0 comments
  2. Jim G 134K Reputation points MVP
    2015-12-04T16:33:00+00:00

    Hi

    As a general rule I reply only after 2 or 3 days have passed with no activity on a new question. If a question goes past that time frame I ignore it until someone tacks on a reply as happened here a long time after the question had become dormant.

    What you described in the reply I am currently responding to is a screen redraw problem. What I think you are saying is that Excel is actually performing the calculation, but the screen is not refreshing as it should.

    This is a problem that should be reported directly to Microsoft using the Smile button in Excel. Microsoft may not even be aware that this problem exists.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-12-04T16:58:05+00:00

    I sent this issue via the Smile/Frown button 3 times already... when first noticed, and then once again after two different updates.  Still no fix.  I'm not sure that anyone ever actually looks at the Smile/Frown reports, nor am I sure this will ever get fixed.  It's been reported on this forum for several months in at least 2 different threads as well as I am sure many people sent it via the Frown.  Ver disappointing that such a known and glaring issue cannot get resolved quickly.

    I pay every month for Office 365, why does Microsoft not have a real ticket system where I can issue a problem, get assigned a case number, and get a trackable response?  Throwing comments into a smiley face black hole is no way to support paying users.

    Was this answer helpful?

    0 comments