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
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,515 questions
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,638 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 21,626 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.