IF Formulas Disappearing

Occasional Visitor


I am using Office 365 on a Windows computer.

I created a spreadsheet full of IF formulas that referenced cells on a different sheet of the workbook. Two of the cells did not return any data, as the cell references were blank.

When I opened the spreadsheet this morning, the formulas were gone and only the values were there. The two cells without any data returned are the only cells that still have formulas in them.

I do not have any macros running.

0 Replies