missing formulas in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1821218%22%20slang%3D%22en-US%22%3Emissing%20formulas%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1821218%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3Ei%20transferred%20a%20CSV%20file%20to%20work%20on%2C%20made%20changes%20and%20all%20good.%20Saved%20it%20and%20today%20the%20formulas%20are%20missing%26nbsp%3B%20-%20values%20are%20there%20and%20correct%20but%20no%20visible%20formulas.%3C%2FP%3E%3CP%3Eany%20idea%20how%20to%20restore%20the%20formulas%20that%20are%20there%20but%20hidden%3F%3C%2FP%3E%3CP%3Ei%20have%20copied%20the%20worksheet%20and%20tested%20if%20i%20can%20use%20it%20and%20i%20can%20and%20when%20i%20write%20a%20new%20formula%20in%20the%20existing%20cells%20it%20shows%20it%20for%20that%20cell%20as%20it%20did%20yesterday.%3C%2FP%3E%3CP%3EI%20have%20contacted%20Microsoft%20and%20they%20suggested%20here%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EWayne%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1821218%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1821669%22%20slang%3D%22en-US%22%3ERe%3A%20missing%20formulas%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1821669%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F846815%22%20target%3D%22_blank%22%3E%40Wayne2206%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20csv%20file%20never%20contains%20formulas%20or%20formatting.%20It%20just%20contains%20values%20-%20hence%20the%20name%3A%20comma%20separated%20values.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

@Wayne2206 

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

 

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