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.
Thank you! I had to replace the semicolons with commas for it work on the desktop and online versions, but besides that this is a good workaround
You may sync online regional settings with your local one in File->Options->Regional Format Settings