Excel 365: Formula to return Tab Name

[eluzzi]

Currently have a workbook with 90 tabs. Each tab is an individual employee name in the format: Smith, John. There is a cell in each worksheet that references the tab name (ie. the employee's name). When working in excel desktop, I was using the following formula and it worked as expected: However, our company just transitioned to Office 365. In Excel 365 or online versions of excel, the formula does not work and returns "#value!". My understanding is that the online versions do not support the "CELL" function. Additionally due to security settings in our company's Excel 365, I am unable to resolve with VBA.

Original formula: =MID( CELL("filename",A1),FIND("]", CELL("filename",A1))+1,255). **fyi: the symbol before "CELL" was removed for this post as it was causing error in posting**

Is there a function in Excel 365 to return the tab name?

Thank you for any advice or assistance.

Ed
Sample.xlsx

[Fluff13]

That formula will work in 365 as long as you open the file in the desktop app.
As far as I'm aware there is no way of getting the Tab name with the online version of Excel.

[eluzzi]

Fluff13,

Thank you for the quick response, I was afraid of that. Our company removed the desktop apps and everything is online through 365 now. I usually develop spreadsheets on home PC with desktop, only to find out certain limitations of the online app after the fact. Oh well. Have a great day.

Ed

[Fluff13]

Sorry I couldn't have been more help.

[menem]

You may get tab name from 2 formulas.

1st. Create a formula (for sample at B1 of tab Sheet1) as
=Sheet1!A1
** Need to insert tab name by yourself in the first time.

2nd. Use FormulaText to read it out.
=MID(FORMULATEXT(B1),2,FIND("!",FORMULATEXT(B1))-2)

Regards.