Excel Web App Formula Problem

Question

I have noticed on a couple of my excel spreadsheets that the formulas disappear and replaced by the resulting number.  I had just finished with one and did a "save as" and the new spreadsheet did not have the formulas.  So I went back to the original and they were gone there too.  Not all of them, just some.  This is a big issue for me as I don't like typing my formulas over and over again.  And it can become a huge issue if I don't catch it and the resulting calculations are incorrect.

Also, I am using IE11 but it was absent from the pull down.

Thanks

Answer 1

If you can share the workbook publicly and share the exact steps to cause the formulas to be removed, we can take a look.  If I understand you correctly, it should not be happening unless the formulas were accidentally overwritten.  I don't know of any current problems with formulas being removed or changed unexpectedly.  So it will help if we have the exact file and exact steps that show the problem.

Answer 2

I added formulas saved it, did a save as, and the new and old spreadsheets no longer had the formulas.  All of the new formulas and some of the old ones were changed.   I did not check when the old formulas were changed.

Answer 3

Can you check the "Version History" in SkyDrive and see which version of the workbook removed the formulas and see what may have changed?

Answer 4

No, and if I change a cell that it was calculating it does not update.  It is just the number.

Answer 5

Does the formula show in the formula bar at the top?  If you press F2 on the cell, does it show the formula?