Formulas disappearing, only values remain in cell

I've been having this problem for a long time now. I have a sheet with over 100 formulas. Several months ago, most of the formulas disappeared. I have reentered them from a backup copy and now many of them have disappeared again but not all of them.

I'm pulling my hair out here, many of these formulas are very large and complex. I'm not sure how formulas can go away with just the calculated value remaining in the cell. And again, it's not all of the formulas, just some of them - maybe 30% or so

If my workbook is corrupted somehow, is there a way to repair it?

Thanks a million

Originally Posted by TMS

Is there a reason you have posted this under Excel Programming?

Yes, It's a large application with about 20 Userforms and several thousand lines of code

Originally Posted by TMS

OK, that makes sense. Couldn't really guess at that though.

Does any of your code copy formulae and paste special | Values? Or do you use .Value = .Value anywhere?

It's possible that you might have inadvertently triggered the code when you have part of a sheet selected ... maybe?

I use code snippets like this for my reports where I access the value from the formula: CStr(Format(ws.Cells(53, 1).Value * 100, "0.00")) & "%"

Thanks for taking a look!

Thank you for the reply. I've never heard of that property so I'm guessing I don't use it. But in reading about it, it's a good idea on your part. I will check my code/forms.

I'm thinking of locking my formulas now. Might that help prevent them from vanishing?

Thanks for the help!

Even if I was just accessing the cell value like this: CStr(Format(ws.Cells(53, 1).Value * 100, "0.00")) & "%"?

Thanks so much