Results 1 to 7 of 7

Thread: Ribbon missing when going from Excel 2007 to Excel 2010

  1. #1

    Ribbon missing when going from Excel 2007 to Excel 2010



    Register for a FREE account, and/
    or Log in to avoid these ads!

    My app has a custom ribbon, developed and run in Excel 2007. Recently, one external user group upgraded to Excel 2010 and now when those users load the app, the opening code runs fine but they do not see the custom ribbon that normally loads after the initial VBA code runs.

    I've found mention of Custom UI Editor's 2010 "part" but I'm confused because much of what was written seems to indicate that the ribbon should work fine in either 2007 or 2010 version (thus, is not a migration issue). I've also read that you only need to use UI14.xml part if you're creating a ribbon with Backstage functionality that's only avail. in 2010. There isn't much posted about folks not seeing the custom ribbon at all when going from Excel 2007 to 2010.

    So, right now I'm wondering:

    Do I need to have all of the ribbon code in BOTH the customUI.xml and customUI14.xml parts? (Seems too redundant)

    Or, do I just need to add the namespace to UI14.xml part but keep all of existing ribbonX code in other part?
    schemas.microsoft.com/office/2009/07/customui

    I'm trying to get a copy of Office 2010 installed for my direct use but don't have it yet to test myself.
    Just looking for some initial guidance or maybe a link or two to related webpage(s) or post(s) so I can solve this ASAP.

  2. #2
    Post your workbook and we can test it.

  3. #3
    Thanks for the offer to try my file. I'd have to get permission from management before I could posit it publicly because it contains proprietrary information. So that's not likely to happen.

    I have been able to install Excel 2010 on my PC (along with the existing Excel 2007) and the app loads with the ribbon just fine. But again, I have both 2007 and 2010 loaded, and I only installed Excel 2010 and Access 2010, not the entire Office 2010 suite.

    Since it runs fine for me, I suspect there's some Office or Excel setting that's stopping the custom ribbon from loading for them. I've tried changing several of my Excel settings in 2010 but the custom ribbon always loads for me fine. Ugh! I'm trying to get our HQ office to find a PC with Excel 2010 to also test. Maybe this field team's setup of MS Office if different from my setup?

    Excel 2010 has been out there for a while now. And I know the ribbon was a bit intimidating to work with in VBA at first, but I hope there are other folks creating custom ribbons...yes? Still, there isn't really anything posted about this on the Web that I can find. Odd. Any other ideas out there??

  4. #4
    Yep, I create custom ribbons all the time, and I haven't come across this.

  5. #5
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,268
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    I haven't run into this yet either.

    What's different between this user's machine and yours? Same OS? Has IT done anything to the machine to lock things down? Are macros enabled?
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  6. #6
    Acolyte misi01's Avatar
    Join Date
    Jul 2011
    Location
    Stockholm,Sweden
    Posts
    31
    Articles
    0

    It can't be as simple as....

    the user having lost the location as a trusted one when they migrated to 2010 can it. (Nahhhh - too obvious)

  7. #7
    Did you ever resolve this issue? I am having exactly the same problem.

Posting Permissions

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