Forum Discussion

Sander154's avatar
Sander154
Copper Contributor
Nov 21, 2021

Sheet name referencing to cell Excel Online

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)

excel

3 Replies

    • Sander154's avatar
      Sander154
      Copper Contributor
      Nov 28, 2021

      SergeiBaklan 

      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.

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Nov 29, 2021

        Sander154 

        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());
}

Resources