Get Sheet name, when file is stored on SharePoint/OneDrive

Good morning,

Googling for a solution, how to copy the sheet name to a cell, I found a solution with the following simple formula:


=MID(CELL("filename";A1);FIND("]";CELL("filename";A1))+1;255)


This formula works as long as the excel file is stored locally on your computer. For testing purposes, I stored a test excel under C:\temp\test.xlsx
and it worked like a charm.

If I use this formula in a Sheet, where the file is stored on SharePoint, it no longer works and I get a value error.

Is there a way, where I can fix the issue? I tried to replace the filename with the path but I am getting the same error.

Maybe you have a better way or a fix for this?


Thanx a lot,

Mike

Thank you so much