Excel Changing from Automatic to Manual Calcuations

Hello,

I have been trying for months to figure out why my Excel files change from Automatic to Manual calculations at random. The file will be working fine, and then change to manual calculations. It doesn't happen all the time, but if I unhide or add a new workbook it will change. I have tried everything I have read and nothing will correct this problem. What can be done? I'm at a total loss, and have spent more time on trying to figure this out than I care to admit. Our office IT Department can't even figure it out. Please provide a solution.

Thanks.

 

Question Info


Last updated May 22, 2018 Views 445 Applies to:

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

You meant to say when you hide the file & then unhide it back, the Calculations changes?

Would request you to provide more information so that we can drill down to the issue.

Windows version

office version

Location of files saved

Where are you adding workbook or your referring to a sheet in a workbook

Are they newly created files or older version of files

From when are you facing this issue

was there any recent changes or system updates made on the machine

is it a laptop or dekstop

Are you on office network or personal computer

Example:

Automatic calculations is set> You hide a workbook & then try using other work books. Calculation is changed to MANUAL. 

Is it what your referring to?

If this response answers your question then please MARK as ANSWER

****Keep Eye on your time not on your watch****

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

No, that's not what I meant. I meant exactly what I typed in my question. When working in an Excel file, with multiple workbooks, the calculation will change from auto to manual at random if I unhide or add a new workbook in the same file.

Windows version - Windows 10 Pro

office version Office 365

Location of files saved - SharePoint

Where are you adding workbook or your referring to a sheet in a workbook - Adding a new workbook

Are they newly created files or older version of files - Older Files

From when are you facing this issue - it's been happening for months 

was there any recent changes or system updates made on the machine - no

is it a laptop or desktop - laptop

Are you on office network or personal computer - office network

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

An excel file is called a workbook. So one file is equal to one workbook. You can't have more than one workbook in a file because it is the file. Each "tab" in the workbook is called a worksheet - you can have multiple worksheets in a workbook.

So it happens when you add a new worksheet or "tab" to your workbook?

Maybe you have a macro in your personal workbook that is set to run and turn off automatic calculations when new worksheets are added.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Yes, it happens when I add a new worksheet or unhide one. I can open a blank workbook and have it set to auto. When I add a new worksheet it will change from auto to manual.

There are no macros. We have tried that option.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Yes, tried that too. The IT Department got me a new laptop and it still does it. We have tried it on different computers with the same results. It has something to do with the file, I'm sure, but we cannot figure it out.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Someone else here posted about the same problem some time ago in an older version of Excel. It was resolved for them. Perhaps that may help.

https://answers.microsoft.com/en-us/office/forum/office_2007-excel/the-calculation-option-keeps-switching-from-auto/2ed29346-b946-4aaf-9c19-83911eea812e

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I read that thread when I first started having issues. Sadly, it didn't help.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I'm not sure if it was asked, but is it one specific file? or any file that you open? If it is for any file, is there always a certain file that you keep open when you have the issue?

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

It's only on certain files, which makes no sense whatsoever. It's a file I have to use from a client for invoicing, but not all the files change. I can work on the file for several hours and it work perfectly, then if I add or unhide, it changes from auto to manual. Files created in-house do not change from auto to manual. I cannot recreate the client files, so I guess I'm stuck with this issue.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.