Worksheet name excel online - cannot read

[Kevineamon]

Hi guys
I've created a new workbook recently, one of it's functions is to pull the start of a worksheet name, which then in turn populates other data.
eg. MrExcel_bla_123

'MrExcel' will get pulled into the cell, using the following formula:-

=SUBSTITUTE(REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),""), "_IO","")

This works fine, does it's job as expected... however... when I upload this to excel online, it fails, giving a #VALUE ! error.

 

[Special-K99]

Dunno if it relates to this or not, but for the CELL("filename"... formula to work the file has to be saved first.
e.g.
I've just entered your formula into a blank sheet and I get #VALUE
If I save the file I still get the error
but if now press F9 to recalculate formulas
I now get the sheet name displayed correctly.

 

[Kevineamon]

Apologies for the slow delay Special, just back in work. I was really hoping this would fix it. Unfortunately not. Even tried save as a different filename and F9ing again. No joy. I'm upload this to a Onedrive - Excel online. I'd suspect this is pointed towards the location of my C drive. Maybe I need to give it a URL or something?