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...
NikolinoDE
Interesting !
Tried it out... Got a #REF.
Instead, it looks like this would work:
=RIGHT(CELL("filename";Sheet1!A1);LEN(CELL("filename";Sheet1!A1))-FIND("]";CELL("filename";Sheet1!A1)))
Notice, in my region, we use semicolon as delimiter...
Enjoy 🙂
BR Peter Rosenberg
Provided the CELL function works in Excel for the web, the formula can now be simplified by using
= TEXTAFTER(CELL("filename",A1), "]")Better still, by defining a 3D range
home
= Jan:Mar!$A$1
= TOCOL(home)one can then create a table of contents
[Note: These formulae are shown on the desktop version of Excel but I believe they read across]