Share via

Unable to access the Developer tab in Excel 2016

Anonymous
2018-11-14T01:15:15+00:00

Hi all,

I recently purchased a copy of Excel 2016 for Mac (16.16.1) 

Until now, I have used every version of Excel and have always been able to access the developer tab and it's underlying functions.  I have just tried to enable it and found that the entire Ribbon panel is greyed out.

Does this mean that although I have a legitimate copy of Excel, I am no longer able to use any of the Developer functions?  Does anyone know how I can access this menu?

Warrick

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Bob Jones AKA CyberTaz MVP 430.3K Reputation points
    2018-11-14T20:59:31+00:00

    Oddly enough, the Developer tab is not activated by way of the Preferences for the Ribbon/QAT. Those prefs pertain strictly to customizing the UI.

    To activate the Developer tab go to Excel> Preferences - View, then check the box at the bottom of the pane.

    9 people found this answer helpful.
    0 comments
Answer accepted by question author
  1. Anonymous
    2018-11-14T19:09:12+00:00

    I am not sure that the Developer tab is available for Permanent license version you have. How if yours I know it is available. But it has to be turned on.

    __________

    Disclaimer:

    The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Volunteer Moderator.

    1 person found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-11-17T09:26:03+00:00

    Hi Warrick,

    Have you checked the Phillip and Bob's suggestion above?

    Regards,

    Tisky

    0 comments