Error Message #Name?

%3CLINGO-SUB%20id%3D%22lingo-sub-2303632%22%20slang%3D%22en-US%22%3EError%20Message%20%23Name%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2303632%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20an%20Excel%20Spreadsheet%20for%20financial%20calculations.%20I%20use%20the%20%3DSUMIFFONTCOLOR%20formula.%20The%20sheet%20worked%20fine%2C%20but%20it%20is%20linked%20to%20One%20Drive%20where%20we%20keep%20our%20shared%20documents.%20Now%20the%20spreadsheet%20is%20not%20working%2C%20and%20I%20get%20this%20error%20message.%20I%20get%20a%20message%20about%20links%20not%20working%2C%20but%20when%20I%20try%20to%20fix%20that%20nothing%20works.%3C%2FP%3E%3CP%3EI%20need%20my%20formulas%20to%20work%20whether%20the%20source%20doc%20is%20on%20One%20Drive%20or%20downloaded%20to%20Desktop.%20I%20need%20to%20fix%20my%20Spreadsheet%20so%20it%20works%20again.%3C%2FP%3E%3CP%3EAny%20help%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2303632%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2304017%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20Message%20%23Name%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2304017%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1039837%22%20target%3D%22_blank%22%3E%40rsolangijohnehydepc%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20the%20files%20which%20are%20located%20on%20synced%20with%20local%20drive%20folder%20return%20file%20path%20will%20be%20URL%20of%20the%20file%2C%20not%20the%20path%20of%20the%20local%20folder.%3C%2FP%3E%0A%3CP%3EIf%20you%20use%20it%20in%20functions%20like%20cell(%22filename%22)%20or%20any%20other%20such%20ones%20you%20need%20toc%20heck%20if%20filepart%20starts%20from%20https%3A%2F%2F%20and%20parse%20accordingly.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.

Any help appreciated.

 

1 Reply

@rsolangijohnehydepc 

For the files which are located on synced with local drive folder return file path will be URL of the file, not the path of the local folder.

If you use it in functions like cell("filename") or any other such ones you need toc heck if filepart starts from https:// and parse accordingly.