Jun 26 2018 07:00 PM - edited Jun 27 2018 08:12 AM
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?
Jun 27 2018 03:21 AM
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?
Jun 27 2018 08:15 AM
Jun 27 2018 09:02 AM
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?
Jun 27 2018 01:41 PM
SolutionI 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.
Mar 29 2021 05:27 AM
Dec 08 2022 03:35 PM
@Adeoti18 I find if one makes the filename shorter if will save the formulas
Jun 27 2018 01:41 PM
SolutionI 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.