List all sheet names in excel for the web

[JoelGDucharme]

Hi, I have found a few ways to get a put a list of all the worksheet names using Excel desktop version. But, these use older formulas that activate macros and don't seem to work on the web version. Am I missing a simple formula or is this just not possible on excel for the web?

[#2]

@JoelGDucharme 

In Excel for the web, you can't use VBA macros or some of the advanced features of the desktop version. Unless you create the macro in a desktop version. However, you can still get a list of all sheet names using a formula.

=INDEX(CELL("filename",Sheet1!A1),1,LEN(CELL("filename",Sheet1!A1))-FIND("]",CELL("filename",Sheet1!A1)))

The formula has not been tried in Excel for web...or at all.

Hope it helps