Forum Discussion
List all sheet names in excel for the web
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. A...
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 
Thanks, I didn't try it out because the person who needed this found another way to do what she was thinking.