Worksheet name excel online - cannot read

Kevineamon

New Member
Joined
Aug 1, 2018
Messages
27
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. :(
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,350
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.
 
Last edited:

Kevineamon

New Member
Joined
Aug 1, 2018
Messages
27
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? :confused:
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,109,250
Messages
5,527,635
Members
409,778
Latest member
MagalieD

This Week's Hot Topics

Top