SOLVED

my formulas are being deleted constantly

%3CLINGO-SUB%20id%3D%22lingo-sub-209139%22%20slang%3D%22en-US%22%3Emy%20formulas%20are%20being%20deleted%20constantly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-209139%22%20slang%3D%22en-US%22%3E%3CP%3Emy%20formulas%20are%20being%20deleted%20constantly%26nbsp%3B%20how%20do%20I%20get%20the%20cells%20to%20remember%20the%20formulas%3F%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EShow%20formulas%20only%20shows%20the%20formula%20I%20created%20this%20session%20not%20any%20of%20my%20past%20formulas.%3CBR%20%2F%3E%3CBR%20%2F%3ESorry%20if%20this%20is%20obvious%20all%20solutions%20I've%20found%20are%20for%20other%20excel%20versions%20or%20for%20other%20problems%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-209139%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2242402%22%20slang%3D%22en-US%22%3ERe%3A%20my%20formulas%20are%20being%20deleted%20constantly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2242402%22%20slang%3D%22en-US%22%3ESo%2C%20you%20have%20a%20formula%20in%20the%20cell%20which%20calculates%20something.%20You%20save%20file%2C%20formula%20exists.%20After%20that%20you%20close%20the%20file%20and%20open%20exactly%20the%20same%20file%20(e.g.%20File-%26gt%3BOpen-%26gt%3B%20latest%20in%20the%20list%20of%20recent).%20Stay%20on%20the%20same%20cell%20and%20see%20nothing%20in%20the%20formula%20bar.%20Correct%3F%3CBR%20%2F%3E%3CBR%20%2F%3EAbove%20mentioned%20is%20my%20problem%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-210065%22%20slang%3D%22en-US%22%3ERe%3A%20my%20formulas%20are%20being%20deleted%20constantly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-210065%22%20slang%3D%22en-US%22%3E%3CP%3EI%20believe%20you%20have%20it%20saving%20as%20a%20csv%20rather%20then%20an%20excel%20file.%20csv%20would%20replace%20formulas%20with%20the%20solution%20and%20save%20it%20like%20that.%20When%20saving%2C%20make%20sure%20that%20your%20save%20as%20type%20is%20Excel%20Workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-209451%22%20slang%3D%22en-US%22%3ERe%3A%20my%20formulas%20are%20being%20deleted%20constantly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-209451%22%20slang%3D%22en-US%22%3E%3CP%3ESo%2C%20you%20have%20a%20formula%20in%20the%20cell%20which%20calculates%20something.%20You%20save%20file%2C%20formula%20exists.%20After%20that%20you%20close%20the%20file%20and%20open%20exactly%20the%20same%20file%20(e.g.%20File-%26gt%3BOpen-%26gt%3B%20latest%20in%20the%20list%20of%20recent).%20Stay%20on%20the%20same%20cell%20and%20see%20nothing%20in%20the%20formula%20bar.%20Correct%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-209428%22%20slang%3D%22en-US%22%3ERe%3A%20my%20formulas%20are%20being%20deleted%20constantly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-209428%22%20slang%3D%22en-US%22%3ESo%20as%20soon%20as%20I%20save%20and%20close%20the%20formula%20goes%20away%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-209270%22%20slang%3D%22en-US%22%3ERe%3A%20my%20formulas%20are%20being%20deleted%20constantly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-209270%22%20slang%3D%22en-US%22%3E%3CP%3EDo%20we%20speak%20about%20Excel%20Desktop%20or%20Excel%20Online%20(you%20added%20both%20tags).%20In%20Excel%20Online%20there%20is%20no%20Show%20formulas%20option.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnd%20what%20do%20you%20see%20in%20formula%20bar%20if%20stay%20on%20such%20cell%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

my formulas are being deleted constantly  how do I get the cells to remember the formulas?  

Show formulas only shows the formula I created this session not any of my past formulas.

Sorry if this is obvious all solutions I've found are for other excel versions or for other problems?

5 Replies

Do we speak about Excel Desktop or Excel Online (you added both tags). In Excel Online there is no Show formulas option.

 

And what do you see in formula bar if stay on such cell?

So as soon as I save and close the formula goes away

So, you have a formula in the cell which calculates something. You save file, formula exists. After that you close the file and open exactly the same file (e.g. File->Open-> latest in the list of recent). Stay on the same cell and see nothing in the formula bar. Correct?

best response confirmed by Hao Sun (New Contributor)
Solution

I believe you have it saving as a csv rather then an excel file. csv would replace formulas with the solution and save it like that. When saving, make sure that your save as type is Excel Workbook.

So, you have a formula in the cell which calculates something. You save file, formula exists. After that you close the file and open exactly the same file (e.g. File->Open-> latest in the list of recent). Stay on the same cell and see nothing in the formula bar. Correct?

Above mentioned is my problem