Forum Discussion
Solved
workbook and sheet name via formula
I have a standard header I put on almost every excel workbook I create I have been using for years. It includes several standard items, including Workbook name and Worksheet name, which are extracted...
Afraid for Excel Online that's only with Office Script, there are properties getName both for workbook and worksheet.
VBA and related functions don't work in Excel Online.
As mentioned before CELL("filename") doesn't work in Excel for web.
Nor in Excel for SharePoint
To my knowledge there is no such app as Excel for SharePoint. Excel for Web is the common name for working with Excel file in browser, doesn't matter where such file is located - SharePoint, OneDrive or other supporting source.
- Oh it matters greatly where the file is located - go and test it for yourself!
Again, file location doesn't matter. It is all called "Microsoft 365 for the web", in particular "Excel for the web".
Get started with Office for the web in Microsoft 365 - Microsoft Support
Basic tasks in Excel for the web - Microsoft Support
and same names on any support page.