Where are the formulas?

Question

excel

Good day.
The company has a problem.
Domain, network drives, MS Office 2003 (they refuse to change, it works - don't touch it), users began to notice that in some spreadsheets, formulas disappear in cells, instead of them values ​​simply remain.

Several people work on documents, not at the same time.

And the next time users start filling out the file, the totals are not recalculated.

Where to dig, what to look for?

Answer 1

There are two options:
- a macro that changes the formula to a value;
- A user who has mastered Copy - Paste Special - Paste as Value