Forum Discussion

Brass Contributor

Sep 18, 2020

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

excel

Excel for web

Formulas and Functions

office 365

SergeiBaklan
Sep 18, 2020
liverlarson

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.

SergeiBaklan

Diamond Contributor

Jul 22, 2023

Jan_Wijninckx

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.

Jan_Wijninckx

Brass Contributor

Jul 23, 2023

Oh it matters greatly where the file is located - go and test it for yourself!

SergeiBaklan
Diamond Contributor
Jul 25, 2023
Jan_Wijninckx

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.
- Guy_Boswell
  Brass Contributor
  Jul 25, 2023
  SergeiBaklan but files still have a location, in a particular site or team page. ANd it rather useful to know where!
  - SergeiBaklan
    Diamond Contributor
    Jul 25, 2023
    Guy_Boswell
    
    By clicking on the file on team site it will be opened in Excel Desktop app or in Excel for the web, depends on your SharePoint library settings. Or by your choice from 3-dots menu.