missing formulas in Excel

Copper Contributor

Hello

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

Thanks

Wayne

2 Replies

@Wayne2206 

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

 

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