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)

1 Reply

@Sander154 

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