Excel 2013 Calculating problem

Excel 2013 is still calculating in Manual calculate mode.

Originally Posted by shg

What happens when you set it to Automatic?

Same problem it just auto calculates when you change something on the document.

That's the expected behavior of Automatic Calculation.

What are you expecting to happen when nothing changes?

Originally Posted by Jonmo1

That's the expected behavior of Automatic Calculation.

What are you expecting to happen when nothing changes?

But it recalculates on manual

Oh, ok. Your description had been pretty vague, but I think I get it now.

So the issue is that when you have it on Manual, formulas still calculate when you change something on the sheet.
Right?

Probably some VBA Event code.
Right click on the Sheet's Tab, View Code
Do you have any code in there?
Look in all the Sheet Modules and the module named ThisWorkBook

Originally Posted by Jonmo1

Oh, ok. Your description had been pretty vague, but I think I get it now.

So the issue is that when you have it on Manual, formulas still calculate when you change something on the sheet.
Right?

Probably some VBA Event code.
Right click on the Sheet's Tab, View Code
Do you have any code in there?
Look in all the Sheet Modules and the module named ThisWorkBook

Looked at the place you said and there was no code in any of the sheets.

Can you post a copy of the book (remove any sensitive data of coarse)