+ Reply to Thread
Results 1 to 13 of 13

Design Tab not showing [Insider Current Channel (Preview) 16.56 for Mac]

  1. #1
    Registered User
    Join Date
    12-23-2021
    Location
    Boston, USA
    MS-Off Ver
    MS 365 version 16.63.1
    Posts
    45

    Design Tab not showing [Insider Current Channel (Preview) 16.56 for Mac]

    Hello!

    The Design Tab does not show in the Developer tab (see screenshot how my Ribbon looks like). I cannot find a solution on the web so far. Anybody has an idea how to add the Design Tab?

    Screen Shot 2021-12-23 at 6.58.43 AM.png

    xxx
    Sarah
    Last edited by 6StringJazzer; 12-23-2021 at 01:10 PM. Reason: enhanced title

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Design Tab not showing

    What version of Excel are you using? Not the release number but the version (Office 365? Office 2021? Office online?) For PC or Mac?

    This looks nothing like any version of Excel I've ever used. I do not see the panel labels here (Code, Add-Ins, Controls) under the panels. In the rightmost panel, you have a list of control icons instead of the usual options. Here is what mine looks like (the Dev Tools panel with an X through it is a custom panel so nobody else would have that).

    developer.JPG
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Design Tab not showing

    Upon searching it appears that you are using a beta version of Office Insider for the Mac. Beta versions can give you all kinds of surprises.

  4. #4
    Registered User
    Join Date
    12-23-2021
    Location
    Boston, USA
    MS-Off Ver
    MS 365 version 16.63.1
    Posts
    45

    Re: Design Tab not showing

    I dont think I have a Beta version. It says Microsoft 365 for Mac (see screenshot).
    Attachment 760537

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Design Tab not showing

    There is a bug in our image attachment feature. To attach an image, first click Go Advanced under your edit box. Then go ahead to press the image icon and attach your image.

    16.56 does appear to be a preview, not beta.

    Nonetheless you are looking at an Insider Preview and not the Current release. I have enhanced your title to give more detail, which may attract more people familiar with this specific release.

  6. #6
    Registered User
    Join Date
    12-23-2021
    Location
    Boston, USA
    MS-Off Ver
    MS 365 version 16.63.1
    Posts
    45

    Re: Design Tab not showing

    Thanks Jazzer. I am confused why I have a preview in the first place. I selected the free trail on the microsoft website, then downloaded the only office version that is available. Help -> Contact Support does not work in my excel desktop app (I posted a separate thread already today). Therefore I post it here. Maybe someone can help.

    Thank you
    Sarah

  7. #7
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Design Tab not showing [Insider Current Channel (Preview) 16.56 for Mac]

    I guess you are referring to the Design Mode button, which does not exist in Mac Excel.

    If that's not what you mean, please clarify, as there aren't any items missing from your screenshot.
    Rory

  8. #8
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Design Tab not showing [Insider Current Channel (Preview) 16.56 for Mac]

    on macos, the "Design" group is related to "Pivot Chart Tools", and so is not part the of "Developer" tab.

    you can check this in excel for macos by going to Excel> Preferences> Ribbon & Toolbar
    then under "Customise the ribbon" selecting All tabs
    then scroll down to "Pivot Chart Tools"

    macos-design.png

  9. #9
    Registered User
    Join Date
    12-23-2021
    Location
    Boston, USA
    MS-Off Ver
    MS 365 version 16.63.1
    Posts
    45

    Re: Design Tab not showing [Insider Current Channel (Preview) 16.56 for Mac]

    I think the design feature under pivot chart is different. I am looking for the "Design Mode" under the developer tab. I contacted MS support, who told me that the "Design Mode" icon only exists in the Windows version of Excel, but not in the Mac version. Also, the Mac version has not ActiveX form controls. Hard to believe for me but that is what support told me. Anybody here who used Microsoft 365 Excel 16.57 and who does have the "design mode" icon and actionX forms under the developer tab?
    Thx Sarah

  10. #10
    Registered User
    Join Date
    12-23-2021
    Location
    Boston, USA
    MS-Off Ver
    MS 365 version 16.63.1
    Posts
    45

    Re: Design Tab not showing [Insider Current Channel (Preview) 16.56 for Mac]

    Thats what support told me, too. Thanks Rory. Do you have ActiveX controls in your Excel for Mac version?

  11. #11
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Design Tab not showing [Insider Current Channel (Preview) 16.56 for Mac]

    No. You cannot use activex controls on worksheets on a Mac.

  12. #12
    Registered User
    Join Date
    12-23-2021
    Location
    Boston, USA
    MS-Off Ver
    MS 365 version 16.63.1
    Posts
    45

    Re: Design Tab not showing

    Thanks Jazzer. I have a 365 subscription with only one option of downloading the Excel desktop version, which I did download. If it is true what you write that it is a preview, why does MS let me only download a preview with limited features. I purchased a subscription, and logically want to use the full version of MS Excel. Who wouldn't. Do you have an idea how to change it to the fully functioning version of Excel?

  13. #13
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Design Tab not showing [Insider Current Channel (Preview) 16.56 for Mac]

    Even with full version… the features that require activex will not be available in mac.. because mac does not use it. Simple as that!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Cell not showing empty instead showing False
    By jimpatel1993 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-24-2021, 10:58 AM
  2. Replies: 2
    Last Post: 12-19-2016, 05:34 PM
  3. Cell with Formula Not Showing Date - Only Showing Serial Number
    By jbb89777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-07-2016, 04:33 AM
  4. Replies: 2
    Last Post: 04-22-2016, 05:25 PM
  5. 2 issues: Password showing and Sheets showing even though hidden in VBA
    By jlheath01 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-21-2014, 10:24 PM
  6. Replies: 4
    Last Post: 06-06-2013, 10:21 AM
  7. [SOLVED] Hyperlinks Inserted in Design Mode inactive once Exited Design Mod
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1