Forum Discussion

asdfaklsfjasdlkf's avatar
asdfaklsfjasdlkf
Copper Contributor
Jul 12, 2022

Name manager missing from Excel for Mac

https://techcommunity.microsoft.com/t5/excel-blog/improved-name-manager-in-excel-for-mac/ba-p/3179498 says that name manager is available for Excel for Mac from 16.58, I have 16.62 and it's not there (and pressing Define Name opens the Define Name dialog, not the Name Manager dialog). A colleague of mine also has Excel for Mac 16.62 and in the Formulas tab there's a large Name Manager button to the left of Define Name and Create from Selection.

 

I've tried customising the buttons in the ribbon but Name Manager isn't anywhere to be found. Anyone know how to make it work?

 

Steve_K_Excel 

  • asdfaklsfjasdlkf  Check your license type. It must be subscription to have this feature. Use the Menu Bar and choose Excel > About Excel to display your version. If your install is managed by an IT department, ask them if the have a delay on new features in place.

    • asdfaklsfjasdlkf's avatar
      asdfaklsfjasdlkf
      Copper Contributor
      When I go do Excel > About Excel it says Licence: Microsoft 365 Subscription
      • JimGMac's avatar
        JimGMac
        MVP

        asdfaklsfjasdlkf 

         

        Hi again

         

        Thanks for replying. Try clicking on the idea light bulb and type Name Manager. Does it appear on the menu? If yes, select it.

         

Resources