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.
Strange thing is that it works momentarily when you open the spreadsheet, displaying the correct value, before reverting to #VALUE!
If you had some value in last saved in desktop version file, it is shown in Online version from cache till you recalculate worksheet. After that an error.