Worksheet name in Dropbox

[hnswart]

I use a formula that returns the sheet name in a cell. I use that returned value in other formulas.
This works perfectly in excel. But when i open the file in Excel for the web(dropbox) so that different people can work on the same workbook without creating conflicted copies the formula does not work anymore.

The formula: =MID(@CELL("filename",A2),FIND("]",@CELL("filename",A2))+1,255)
It returns #False!
When i open it again in excel i get the sheet name.

Does anyone have a formula that could work on the online version?

Thank you

 

[daverunt]

Hi,

I don't think Excel has a built in function to get the sheet name hence the formula that is prevalent on the net.
This site explains the formula, which returns the path and the wb/sheet name.
It might be worth seeing what just the filename A1 returns to see if there's anything useful that can be used.

Get sheet name only

To get the name of the current worksheet (i.e. current tab) you can use a formula based on the CELL function together with the TEXTAFTER function. In the example shown, the formula in E5 is: =TEXTAFTER(CELL("filename",A1),"]") The result is "September" the name of the current worksheet in the...

exceljet.net

 

[hnswart]

Hi,

I don't think Excel has a built in function to get the sheet name hence the formula that is prevalent on the net.
This site explains the formula, which returns the path and the wb/sheet name.
It might be worth seeing what just the filename A1 returns to see if there's anything useful that can be used.

Get sheet name only

To get the name of the current worksheet (i.e. current tab) you can use a formula based on the CELL function together with the TEXTAFTER function. In the example shown, the formula in E5 is: =TEXTAFTER(CELL("filename",A1),"]") The result is "September" the name of the current worksheet in the...

exceljet.net

I see that the CELL("filename") formula is not supported by Online or mobile versions of excel.

Thank you for your help.