Excel for Web and Getting Sheet Name

ajones

Board Regular
Joined
Oct 26, 2002
Messages
106
I use formulas like
=MID(@CELL("filename",'sheet name'!$A$1),FIND("]",@CELL("filename",'sheet name'!$A$1))+1,256)
to get the sheet names and dynamically update. I will even embed that in the hyper link function to jump from sheet to sheet. However I have learned that Excel for web does not support "filename" in the CELL() function.

Does anyone have any other techniques to dynamically get sheet names in Excel.
I want it dynamic so that if I change a sheet name the other info updates properly.

This makes reference to what is not supported in Excel for web.

Any other thoughts or ideas?

thanks
Alan
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
What part of the Cell function does not work with Excel for the web?
The link starts with " CELL function Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 .."

Try one or more of the following. You do not need to use Let.

Let_a.xlsm
ABCD
18D:\Excel16\[Let_a.xlsm]1c
19Let_a.xlsmFile name without path
20Let_aFile name without extension
211cSheet name
1c
Cell Formulas
RangeFormula
A18A18=CELL("filename",A1)
A19A19=LET(FileN,CELL("filename",A1),REPLACE(LEFT(FileN,FIND("]",FileN)-1),1,FIND("[",FileN),""))
A20A20=LET(FileN,CELL("filename",A1),REPLACE(LEFT(FileN,FIND(".",FileN)-1),1,FIND("[",FileN),""))
A21A21=LET(n,CELL("filename",A1),MID(n,FIND("]",n)+1,99))
 
Upvote 0
the problem is in the CELL function "filename" does not work.

See the link I shared for "filename"
1657381417772.png

 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,150
Members
448,552
Latest member
WORKINGWITHNOLEADER

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top