Get The Workbook And Sheet Name With A Formula

less than 1 minute read

These formulas require that the workbook is saved

Get the file name of this workbook:


Result: C:[MyWorkbook.xlsx]Sheet1

Get the file name of this workbook without the file extension:


Result: MyWorkbook

Get the active sheet name:


Result: Sheet1

Reference another sheet name:


Result: ‘Sheet1!