Formulas no longer work automatically

Good evening

It is possible that despite the automatic calculation mode, the formula does not calculate, which means that Excel considers your cell as text. It is therefore possible that this cell was previously set to text format. To solve this small issue, you can either remove the formats from the cell or set it to number format.

To test

Best regards

Good evening,
thank you for this information. I looked at the format; it is monetary for all the cells. It's a bank account table. Do you have another lead?

I'm sorry, but I don't understand. Where can I find the file link?

Re

I'm not talking about any link but about enabling iteration mode by going to File / Options / Formulas / Calculation mode

Cheers

Concretely, how do I do it?
Where do I find "file"?

Re

In fact, in the statement of your first post, you said that you checked in formulas, calculation options, I am indeed in automatic so iteration is right next to Automatic

If not, send a dummy file whose formulas do not work automatically and I will see why.

Well no, I don't have iteration in calculation options, my Excel version is 2007.

Re

Put a dummy file on Cjoint.com with a simple calculation that doesn't work on its own and I'll see why

1) Go to https://www.cjoint.com/
2) Click on [Browse] to select your file
3) Scroll down to the bottom of the page to click on [Create Cjoint link]
4) After a few seconds, the second page appears, with the link
in blue underlined; select it and click "Copy"
5) Return to your discussion on CCM, and in your reply message
paste it.

Hello,

I looked at the format, it is monetary for all the cells
It is also necessary that these are real numbers and not text.
Without forced alignment, a number aligns to the right, a text to the left.
Eric

--
By continually trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to the thank you (yes, yes, it happens!!!), remember to mark it as resolved. Thank you