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-02-05T16:13:45+00:00

    Well at least someone at MS saw it - do you have an open ticket number with them you can pursue?  Thats the only way this will ever get fixed.

    Seems like ever since Bill left, Microsoft really took a down turn in quality and support...

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-02-05T16:09:07+00:00

    I tried the same thing last night.  They even remoted into my system and were able to see the problem for themselves - right in front of their own eyes.

    What perplexes me further, is that no one else is really making a big deal about this.  We rely on the spreadsheets producing accurate data.  I am making business decisions based on what these spreadsheets yield.  If they are wrong, it can result in the loss of real dollars to my company.  Before I noticed the problem, I ran my P&L and based on what I saw (incorrectly) I was going to have a layoff this week and let 4 employees go!

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-02-05T15:54:48+00:00

    I agree - 15.18 is still broken.

    Whats more - I tried to contact Microsoft on this by opening a ticket - spent 56 minutes on the phone being bounced back and forth between Home support and Business support and eventually being told I would have to pay $499 to open a ticket.  So basically I have to pay $499 to report their bug because they refuse to look at their own support forum - unreal!

    Was this answer helpful?

    0 comments