OneDrive seems to be stamping all formulas as values.

Copper Contributor

I have an Excel workbook that I created yesterday, which contained a mixture of formulas and static cells.  This workbook is saved in my OneDrive folder.  At 6:30pm, I closed the workbook for the night and saved it.  Today, when I re-opened the workbook, I found that all cells that previously contained formulas now only contains static values. 


Although I was able to find a version of the report that still had the formulas, which helped me in re-creating some of the work that I had done, if I tried to save it in OneDrive again, the problem would occur immediately.  I am now having to save the workbook on my local PC and can't add it to OneDrive without this problem occurring again.

0 Replies