Forum Discussion

liverlarson's avatar
liverlarson
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's avatar
    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.

HughBT's avatar
HughBT
Copper Contributor
Nov 21, 2020

NikolinoDE Before moving to Office 365 I used this function to include the workbook name in the Heading of the Workbook (not in the header) so new versions automatically pick up the right name. It almost works in 365, using =MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-6) but as soon as I open a 2nd workbook it changes the content of the cell in the 1st workbook to the filename of the newly opened workbook. Very frustrating and confusing!

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Nov 21, 2020

HughBT 

 

Excel

ExcelApplication features Excel for the web Excel desktop app
Accessibility CheckerYesYes
Add background color to sheet tabsYesYes
Add hyperlinksYesYes
Advanced time filtering (Timeline slicer)NoYes
AlignmentYesYes
Apply conditional formattingYesYes
Apply smart/recommended formattingNoYes
Audio notes recordingNoYes
AutocompleteYesYes
AutoSumYesYes
CalculationsYesYes
Cell references in formulasYesYes
Comment creationYesYes
Copy and pasteYesYes
Create external data connections2No3Yes
Create tablesYesYes
Creation of advanced analysis views (Power View, Power Pivot, Slicers)NoYes
Data validationYesYes
Drag and drop cellsYesYes
DropboxYesYes
Duplicate (copy) worksheetsYesYes
Embed workbook on web or blog page (OneDrive)YesNo
External referencesNo4Yes
Fill handleYesYes
FindYesYes
Font and cell formattingYesYes
Formula barYesYes
Formula tools, advancedNoYes
Freeze panesYesYes
Full fidelity reading viewYesYes
Functions YesYes
GoToYesYes
Group dataYesYes
Hide/unhide rows, columns, and sheetsYesYes
Insert chartsYesYes
Insert/delete rows and columnsYesYes
Insert picturesYesYes
Insert shapesYesYes
Merge cellsYesYes
Named rangesYesYes
Number formattingYesYes
Office Add-insYes5Yes
Offline viewing and authoringNoYes
PivotChartsYes1Yes
PivotTablesYesYes
Post to social network and present onlineNoYes
Power Pivot viewingYesYes
Power View viewingYesYes
PrintYesYes
Real-time co-authoringYesYes
Recommended chart creation and editing with formatting controlsNoYes
Refresh existing data connectionsYesYes
Remove duplicate valuesYesYes
Rename and add sheetsYesYes
Rename file while workbook is openYesNo
ReplaceYesYes
Rights management: IRM and password securityNoYes
Save or download a copyYesYes
ShareYesYes
Sheet protectionYesYes
SlicersYesYes
Sort and filter dataYesYes
Spreadsheet audit and complianceNoYes
Status bar aggregatesYesYes
SurveysYesNo
Tell MeYesYes
Text formattingYesYes
Total dataYesYes
Undo and redoYesYes
VBA and macro scriptingYes3Yes
View 3D chartsYesYes
What if analysis toolsNoYes

 

Feature availability

https://docs.microsoft.com/en-us/office365/servicedescriptions/office-online-service-description/office-online-service-description

 

Thank you for your patience and time.

 

Wish you a nice day / night with lots of health, joy and love.

 

Nikolino

I know I don't know anything (Socrates)

  • Jan_Wijninckx's avatar
    Jan_Wijninckx
    Brass Contributor
    Jun 27, 2023
    Thank you so much, this is gold !

Resources