Share via

Excel files not saving formulas

Anonymous
2020-01-22T23:12:09+00:00

I have now worked on and saved 5 excel files that when I re-open only absolute value of cells are saved.  All formulas are gone! I cannot find any settings that would affect this.  Can anyone tell me what's going on?"

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2020-01-22T23:19:15+00:00

Hi CLOfromCO,

Good day! this is Arjie an independent advisor and I'm happy to assist you today.

Could you please check if the workbook is saved as .csv extension. If it is, please save it to .xlsx format.

Thank you.

Regards,

Arjie

Was this answer helpful?

5 people found this answer helpful.
0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Anonymous
    2020-01-22T23:25:34+00:00

    Thanks.  Discovered issue about the same time.  Didn't realize files I had received were CSV format.  Thx!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2020-01-22T23:21:03+00:00

    Found cause.  File type was set to CSV

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments