excel online how to find the name manager

Question

Hello,

I am trying to display the name of workbook tabs on a sheet.

This tutorial shows a method of doing it, but I cannot make it work with excel online.

https://www.howtoexcel.org/how-to-generate-a-list-of-sheet-names-from-a-workbook-without-vba/

Is this the best way to list the workbook sheetnames?

This tutorial shows how to find the defined name manager in Office 365, but it isn't showing on my menu.

https://support.microsoft.com/en-us/office/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64

Where is the name manager?

Thanks!

Answer 1

Hi Cliff,

Thank you for helping with this. I think this post should be split to another support request as this part of the question isn't the same as the question title.

I am still struggling with the Power Automate. I have made an manual flow. There are so many settings to choose the location I had to set up a test file on the ' SharePoint Site - All Company' as individual accounts don't seem to file the relevant folders. It now runs successfully but it doesn't list the worksheet names, just add a new row to the table. So I obviously have some of the settings set up wrong. I shall have to explore this more when I have time.

Thank you.

Answer 2

Dear riverrunsthroughit,

Appreciate you post back and share updates with us. I really appreciate your effort and your precious time doing.

Per my search and test, it may still need to use formula and name manager, or VBA solution to list workbook sheet names.

I understand you want to list workbook sheet names from Excel Online.

Please allow us some time and we will try to test further and check if there is other way (may be Power Automate) to achieve this requirement in Excel Online. We will post back as soon as we get any update.

Thanks for your cooperation and understanding! I hope that you are keeping safe and well.

Sincerely,

Tina | Microsoft Community Moderator

Answer 3

Dear riverrunsthroughit,

Greetings! Thank you for posting in Microsoft Community.

As per your description, you want to list the workbook sheetnames and find the name manager in Excel Online.

We checked the first tutorial you shared and found the method involves VBA.

As mentioned in this article Work with VBA macros in Excel for the web - Microsoft Support

We cannot create, run, or edit VBA (Visual Basic for Applications) macros in Excel for the web (Excel Online).

And as described in the second tutorials you mentioned Define and use names in formulas - Microsoft Support

For now, creating a new Named Range in Excel for the web(Excel Online) is not available.

Per our searching, we're afraid it may still need to use VBA or name manager to list sheet names in a workbook.

Considering that these 2 features are not available in Excel for the web, if you have Excel desktop application, we would recommend you use Excel desktop application. Thanks for your understanding!

Hope above helps!

If our understanding of the scenario is not consistent with yours, feel free to point it out. We will continue helping you.

Hope you keep safe and healthy always!

Sincerely,

Tina | Microsoft Community Moderator

Answer 4

Thanks for looking into this for me.

The name manager tutorial I was looking at says it applies to 'Microsoft 365' so I thought that was compatible with the online version we are using. If there are two instances of Microsoft 365, they should rename one of them! We are finding it very hard to move our existing excel files from the existing version to the online version which seems to have a lot less capability and all the online help and tutorials are outdated.

The worksheet tab tutorial I was looking at has 'without using VBA' in the title, maybe that is misleading? I shall continue this research on a different post.

Very frustrasted.

Answer 5

Dear Riverrunsthroughit,

If you want to only stay in Excel for the web, you may create the flow below to find all the worksheets in the workbook and then log them to the sheet Workbook Tabs automatically.

However, you may create the links to the worksheets one by one manually by the Hyperlink feature as the name manager formula mentioned in the provided article isn't supported in Excel for the web directly.

You can first let the flow to automatically paste the link text and then copy and paste the text to create the links quicker.

Meanwhile, as our product developers are willing to hear users' feedback and are continuing to bring more features to Excel for the web. I kindly suggest you submit your feedback on the Feedback platformto our product developers so that they can know your requirements and ideas for product improvements.

Thanks for your understanding and have a nice day!

Sincerely,

Cliff | Microsoft Community Moderator