Share via

Excel formulas disappeared after saving document

Anonymous
2018-04-30T11:37:30+00:00

I received an excel spreadsheet of exported data which I edited using formulas. After saving and re-opening the spreadsheet, the cells which previously had formulas in them now just have the value present. The formulas have totally disappeared. Is there any way of retrieving the original formulas?

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

1 answer

Sort by: Most helpful
  1. Anonymous
    2018-04-30T12:29:24+00:00

    Not that I know of in the spreadsheet itself. You would have to find an earlier version of the file. This is possible if you use OneDrive:

    https://support.office.com/en-us/article/restor...

    Was this answer helpful?

    0 comments No comments