Forum Discussion

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 onl...

excel

SergeiBaklan

Diamond Contributor

Nov 21, 2021

Sander154

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

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

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