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
Bookmarks