Nov 21 2021 08:13 AM
Hello everyone,
I have a question related to referencing the tab name to a cell in excel 365 online. In the regular version of Excel, the formulas below work properly, but if the sheet is put online, the formula will not work.
Anyone have any ideas/options to get this done?
formulas i used (also in dutch)
=CELL("filename")
=RIGHT(CELL("filename"),LEN(CELL("filename"))- MAX(IF(NOT(ISERR(SEARCH("\",CELL("filename"), ROW(1:255)))),SEARCH("\",CELL("filename"),ROW(1:255)))))
=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)
Nov 21 2021 11:11 AM
CELL( "filename" ) is not supported for Excel Online.
Nov 28 2021 12:19 PM
Thanks for the reply.
I know that the formula mentioned in my post is not working in Excel Online.
That's why I am asking the community if there is a possible solution for my problem.
Nov 29 2021 03:30 AM
Office script could work, like
function main(workbook: ExcelScript.Workbook) {
let sheet = workbook.getActiveWorksheet();
sheet.getRange("A1").setValue(workbook.getName());
sheet.getRange("A2").setValue(sheet.getName());
}