missing formulas in Excel

New Contributor


i transferred a CSV file to work on, made changes and all good. Saved it and today the formulas are missing  - values are there and correct but no visible formulas.

any idea how to restore the formulas that are there but hidden?

i have copied the worksheet and tested if i can use it and i can and when i write a new formula in the existing cells it shows it for that cell as it did yesterday.

I have contacted Microsoft and they suggested here



2 Replies


A csv file never contains formulas or formatting. It just contains values - hence the name: comma separated values.


i redid the formulas and saved as excel file - all good