+ Reply to Thread
Results 1 to 5 of 5

Ribbon buttons disabled: Insert [Illustrations, Charts, Filter, Text: Text Box, WordArt...

  1. #1
    Registered User
    Join Date
    09-07-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Question Ribbon buttons disabled: Insert [Illustrations, Charts, Filter, Text: Text Box, WordArt...

    Hi,

    I've come across something bizarre in Excel 2010..

    In one particular spreadsheet I have lost the ability to use lots of functionality in the Ribbon.

    The following functions are disabled / greyed out:

    Insert
    - [Illustrations]
    - [Charts]
    - [Filter]
    - [Text]: Text Box
    - [Text]: WordArt
    - [Text]: Signature Line
    - [Symbols]: Equation

    Developer
    - [Controls]: Insert <--- THIS IS THE ONE I NEED!!!

    I have no idea what I did.. but the functionality is disabled for all sheets in the spreadsheet. If I create a new spreadsheet, they are no longer disabled??

    In addition to this, all of my ActiveX buttons and text boxes have disappeared from the sheets, and my list data validated cells no longer bring up a drop down menu, and don't accept any valid strings (when I enter a string from the list that it's using, it just comes up with "This is not valid, Try again")

    I REALLY don't want to try to copy the stuff in my sheets across to a new one.. Funnily enough though, if I copy a sheet to a new spreadsheet, I can access all of the aforementioned features.

    Does anyone have an explanation and how to fix this?


    Thanks,

    Nick

    PS. See attached for the spreadsheet (with sensitive info removed)
    PPS. The spreadsheet is not Protected! (nor is the workbook)
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,985

    Re: Ribbon buttons disabled: Insert [Illustrations, Charts, Filter, Text: Text Box, WordAr

    File > Options > Advanced > Display options for this workbook > For objects, show: All
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-07-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Ribbon buttons disabled: Insert [Illustrations, Charts, Filter, Text: Text Box, WordAr

    Wow, that was easy.. I'm not sure how that option was set, but thank you!

  4. #4
    Registered User
    Join Date
    09-07-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Ribbon buttons disabled: Insert [Illustrations, Charts, Filter, Text: Text Box, WordAr

    Actually, the buttons have come back but the '[Developer] Insert' button is still greyed out and I can't select the buttons on the sheet. I can press them, but when I go to select them in Design Mode, I can't. It's as if they're locked.

    Any ideas?

    Thanks!
    Last edited by Applez00800; 11-20-2012 at 07:46 AM.

  5. #5
    Registered User
    Join Date
    08-10-2012
    Location
    california
    MS-Off Ver
    Excel 2010
    Posts
    2

    Cool Re: Ribbon buttons disabled: Insert [Illustrations, Charts, Filter, Text: Text Box, WordAr

    Quote Originally Posted by Andy Pope View Post
    File > Options > Advanced > Display options for this workbook > For objects, show: All
    Thank you! Whew!

  6. #6
    Registered User
    Join Date
    07-17-2014
    Location
    Minneapolis, MN, USA
    MS-Off Ver
    2010
    Posts
    1

    Re: Ribbon buttons disabled: Insert [Illustrations, Charts, Filter, Text: Text Box, WordAr

    I found another way the Excel 2010 Insert ribbon gets disabled: Review > Share Workbook > Allow changes by more than one user.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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