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
=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