I created an Excel Spreadsheet for financial calculations. I use the =SUMIFFONTCOLOR formula. The sheet worked fine, but it is linked to One Drive where we keep our shared documents. Now the spreadsheet is not working, and I get this error message. I get a message about links not working, but when I try to fix that nothing works.
I need my formulas to work whether the source doc is on One Drive or downloaded to Desktop. I need to fix my Spreadsheet so it works again.