Share via

Excel document not saving formulas and comments

Anonymous
2016-03-06T19:17:28+00:00

Excel version 12.3.6

All formulas, border changes and comments created and saved do not appear when the document is re-opened.

Microsoft 365 and Office | Excel | For home | MacOS

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
2016-03-07T12:59:59+00:00

That's completely unusual. Did you open the file as a text file? If so, you need to save it an as Excel file. Text files are just that, text and can not contain any formatting. So you need to change the file type when you first save the file.

Was this answer helpful?

4 people found this answer helpful.
0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2016-03-07T20:12:46+00:00

    Hi Bob

    Yes, it was an oversight on my part. The file was saving as a '.csv' file.

    Thank you.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments