How am i able to create a developers tab in excel on a shared file ?

Rumaisa Zaker 1 Reputation point

I am creating a spreadsheet with many questions. for one of the questions I need to add a drop-down menu with Multiple selections for the answer. when I do this on excel on the normal desktop it just works fine and allows me to an additional tab for the developer. However, when I try and customise ribbon on a file in the shared file so all parties can see it, it does not work? does anyone know why this may be ? Many thanks in Advance

Microsoft Graph Teamwork API
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,363 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 11,561 Reputation points Microsoft Vendor

    Hi @Rumaisa Zaker ,
    Did you enable any shared feature in Excel?
    How did you create the developer tab?
    How did you shared the file?
    In my opinion you should you export your customize ribbon, go to File- Options- Customize Ribbon- Import/Export- Export the customize ribbon:


    Shared the Customize Ribbon and import to shared usrs.

    Try to provide more information and I'm glad to help you.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.