Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Missing Main Toolbar Excel 2010

  1. #1
    New Member
    Join Date
    Mar 2014
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Missing Main Toolbar Excel 2010

    I cannot determine how to show my main toolbar. I can see my add-ins toolbar but not the original toolbar.
    Help is appreciated. I tried CRTL+F1 but all I get is a help screen.
    Thanks,

  2. #2
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,813
    Post Thanks / Like
    Mentioned
    48 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Missing Main Toolbar Excel 2010

    Do you mean that the only tab you can see is AddIns?

  3. #3
    New Member
    Join Date
    Mar 2014
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Missing Main Toolbar Excel 2010

    All I can see is Kutools Enterprise Add-Inns PowerPivot and Power Query tabs. I cannot see my Main ribbon with with Home Insert Page Layout etc.
    Thanks

  4. #4
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,813
    Post Thanks / Like
    Mentioned
    48 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Missing Main Toolbar Excel 2010

    Assuming that's still true after a restart of Excel:
    1. Have you been customising the ribbon/qat yourself recently?
    2. Do you have an Excelnn.xlb file anywhere on your system?
    3. Does it happen if you restart Excel in Safe Mode (hold the Ctrl key while starting the application)?

  5. #5
    New Member
    Join Date
    Mar 2014
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Missing Main Toolbar Excel 2010

    Ok, I have no .xlb file anywhere in my system. But I did open in "Safe" mode and there is the toolbar! Why is that and is there a way to fix this?

    Thanks very much.

  6. #6
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,813
    Post Thanks / Like
    Mentioned
    48 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Missing Main Toolbar Excel 2010

    It sounds like one of your add-ins or startup files is removing the default ribbon. Try disabling them all and then restart Excel normally.

  7. #7
    New Member
    Join Date
    Mar 2014
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Missing Main Toolbar Excel 2010

    Thanks very much. So why is it that when I have enabled the Com Add Ins that my normal menu goes away? This just started.

  8. #8
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,813
    Post Thanks / Like
    Mentioned
    48 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Missing Main Toolbar Excel 2010

    Has one of them been updated recently?

  9. #9
    New Member
    Join Date
    Mar 2014
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Missing Main Toolbar Excel 2010

    Not that I am aware of.
    Thanks.

  10. #10
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,813
    Post Thanks / Like
    Mentioned
    48 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Missing Main Toolbar Excel 2010

    That's the only reason I can think of. Have you isolated which one causes the problem?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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