Sheet name referencing to cell Excel Online

%3CLINGO-SUB%20id%3D%22lingo-sub-2990533%22%20slang%3D%22en-US%22%3ESheet%20name%20referencing%20to%20cell%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2990533%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20question%20related%20to%20referencing%20the%20tab%20name%20to%20a%20cell%20in%20excel%20365%20online.%20In%20the%20regular%20version%20of%20Excel%2C%20the%20formulas%20below%20work%20properly%2C%20but%20if%20the%20sheet%20is%20put%20online%2C%20the%20formula%20will%20not%20work.%3C%2FP%3E%3CP%3EAnyone%20have%20any%20ideas%2Foptions%20to%20get%20this%20done%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eformulas%20i%20used%20(also%20in%20dutch)%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DCELL(%22filename%22)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DRIGHT(CELL(%22filename%22)%2CLEN(CELL(%22filename%22))-%20MAX(IF(NOT(ISERR(SEARCH(%22%5C%22%2CCELL(%22filename%22)%2C%20ROW(1%3A255))))%2CSEARCH(%22%5C%22%2CCELL(%22filename%22)%2CROW(1%3A255)))))%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DMID(CELL(%22filename%22)%2CSEARCH(%22%5B%22%2CCELL(%22filename%22))%2B1%2C%20SEARCH(%22%5D%22%2CCELL(%22filename%22))-SEARCH(%22%5B%22%2CCELL(%22filename%22))-1)%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2990533%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2990735%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20name%20referencing%20to%20cell%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2990735%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1216859%22%20target%3D%22_blank%22%3E%40Sander154%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECELL(%20%22filename%22%20)%20is%20not%20supported%20for%20Excel%20Online.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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)

3 Replies

@Sander154 

CELL( "filename" ) is not supported for Excel Online.

@Sergei Baklan 

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.

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