roscoe
Well-known Member
- Joined
- Jun 4, 2002
- Messages
- 1,046
- Office Version
- 365
- Platform
- Windows
- MacOS
Coworker of mine sent me a spreadsheet that whenever he saves it, some (but not all) of the formulas are being converted to the value and not saving the formula. He has to recreate it every time.
However, the problem did not occur for me. I edited/saved multiple times and it always came back to the way I saved it. It appears that this only occurs for formulas that are referencing other sheets (it's a financial "roll-up" sheet) , but I don't guarantee that. The other detail I noticed (should be irrelevant but...) is that is is saved in an Excel 97 format.
Any ideas? Since I couldn't reproduce it I couldn't offer any help...
However, the problem did not occur for me. I edited/saved multiple times and it always came back to the way I saved it. It appears that this only occurs for formulas that are referencing other sheets (it's a financial "roll-up" sheet) , but I don't guarantee that. The other detail I noticed (should be irrelevant but...) is that is is saved in an Excel 97 format.
Any ideas? Since I couldn't reproduce it I couldn't offer any help...