Forum Discussion
Error Message #Name?
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 spreadsh...
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.