Automatic calculation turning off randomly in Excel 2016

Hi,

It will, potentiality, change each time you open a new workbook, depending on the last saved status of that workbook.

It then changes across all open workbooks.

If you then save any of those workbooks, the calculation status is saved with it.

This is likely what gives the appearance of being random, but actually isn't.

Alan.

OK, so the user should make sure that when they save a file, the calculation is set to Automatic and then when it opens that workbook and following opened workbooks should be on Automatic? Is that it?  I don't think they have Add-ins...but I can check.

I'd say if an 'advanced' user turns calc to manual he should be returning to the drawing board for a redesign of the file, it aparently has some inefficient calculations.

Hi,

Yes - that would be one reason I guess.  In my experience, more common would be to give greater visibility on complex models, especially when testing perhaps, but it will be a personal preference as to when.

Nice site by the way.

Alan.

Thanks :-)

Thanks to both of you. What you are all saying is basically, make sure your file is set to Automatic Calculation before saving and make sure you have no add-ins that set calculation to manual. Is there anything new in Office 365 that would trigger this as it seems to be a new thing for them...? Thanks

No, Excel has worked like this for as long as I remember (I started using Excel in 1994).

OK. It's just the users I had described it as a new thing for them...and they have been using Excel for a while..although not as long as you @jkpieterse :-)

Beats me - I started in 1995 when Excel 95 came out.

I was using Lotus 123 for a few years before that though :-)

I still have my Excel4 macro reference guide embedded in my personal.xls though!

Alan.

Question answered.