Excel 2016 for Mac does not recalculate

Anonymous

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?

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

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

0 comments

Answer accepted by question author

Anonymous

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

0 comments

112 additional answers

Anonymous

2016-07-22T18:10:25+00:00

Hello! We are so sorry you are continuing to experience this issue. Our support team will be reaching out to a few people to ask you for help in reproducing this. If you have a file that consistently repros, and can tell us repro steps, that will be a great help!!!

As a first step, we need to confirm that you have manual calculation mode turned off. This can be turned on inadvertently. If the first file opened during a session has manual calc mode turned on, then subsequent files opened during the same session will also get manual calc mode turned on. When you save any of those files, the setting will be saved in the file. It's an application setting that is controlled by the first file opened during a session.

Can you please take a look and see if perhaps this was turned on at some point along the way?

Freya

Office Newsroom
Was this answer helpful?

0 comments No comments
Anonymous

2016-07-19T23:27:54+00:00

have one monitor a late 2011 MacBook pro - I have this problem, and have had since Office 2016 came out
Was this answer helpful?

0 comments No comments
Jim G 134K Reputation points MVP

2016-07-19T17:05:07+00:00

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

Hi Anthony,

Yes I am a fast track member, but no I can't report it for you because I don't have two monitors and can not reproduce the problem.

You can (and should) report the problem using the Smile button in Excel after each Microsoft Office update that you install and after each Mac OS update that you install and let Microsoft know whether or not the problem you are experiencing has been corrected. In all likelihood you won't get a personal reply, but those submissions go directly to the Excel product team.

From the recent comments in this thread it seems there is more than one scenario causing a similar problem for users. Hardware is certainly a factor (two monitors is a minimum hardware configuration to have the problem at all). Whether it is a video driver issue, refresh issue, an Excel issue, a Mac OS issue or some specific combination of these factors I don't know. I can't do much to solve this mystery as I can't even reproduce it.
Was this answer helpful?

0 comments No comments