Cayenne. All icons on my insert and data tab is greyed out: Lily: 12/30/08 12:30 PM: I was attempting to create a pie chart and clicked the pie chart icon. • The file is not shared or protected. Hi. The options work when I open excel in safe mode. 3,551 2 2 gold badges 17 17 silver badges 42 42 bronze badges. Make sure you have multiple shapes or pictures selected. I have an Excel document that I want to add arrows to, but the autoshapes options are all greyed out. Discussion created by Guest on Apr 27, 2006 Latest reply on Jan 11, 2016 by Igor Fomenko. How to enable insert button: Once you remove the multiple sheet selection Insert button will be enabled. You can insert graphic shapes such as lines, rectangles, block arrows, stars, and other basic shapes in your Excel 2010 charts and worksheets. share. Open the document in Excel Click the Review Tab If the "Unprotect Sheet" exists but is greyed out Click the Share Workbook button Uncheck "Allow changes by more than one user at a time" && click OK The "Unprotect Sheet" button should no longer be greyed out Click the "Unprotect Sheet" Enter the password and click OK Note: I am very new to excel. I have established a table already on this page, so EDIT table may be more appropriate. However, it DOES work normally if I copy and paste part of it into a new sheet. Insert Illustrations disabled (grayed out) in Excel 2007 Showing 1-11 of 11 messages. This person is a verified professional. • The worksheets are not grouped. All my excel docs now have a greyed out Unshare Button. On the Insert tab, click the Illustrations option, then click the Shapes option. Hi Excel Forum, I am trying to add a table to a chart I’ve created, but the option is greyed out as is pivot table. However, did not want it embedded in the same Work sheet, so I clicked on the new work sheet tab. X. Xx7 … A free add-in offers similar functionality for earlier versions of Excel. Tried this by drawing across cells and drawing over a chart I inserted, and in both cases the drawing was retained. I also tried going to the "Insert" ribbon but the only thing that is not grayed out on that ribbon is "Header & Footer". Visibility: Bill of Materials … This thread is locked. Is there an option somewhere to turn on/off autoshapes? I am having an Excel 2010 workbook with macros. That is strange since this is not necessary to insert a standard SW Table-Based BOM. Insert Text Box is greyed out on an Excel 2010 spreadsheet Many times I have added a text box to an Excel spreadsheet, but on a spreadsheet that I'm currently creating, after clicking Insert on the ribbon I find the Text Box button greyed out. share | improve this answer | follow | answered Nov 17 '11 at 2:20. It’s important to install updates for entire office version you have installed to acquire the complete result of fix. Click Options. If you insert a shape in your workbook, and add text to it, you cannot just pick the text up and move it to the right if you want more space on the left, so you can set the margin. It had to do with the user's privacy settings for Office 365. The reason Data Validation is Greyed Out is due to the characteristics of your spreadsheet. The first is by setting print areas (Les Black answer explains it perfectly). This happens in all workbooks, including brand new ones. Suggestions are welcome. Thought it was a problem with the project I’m using but it isn’t available on a new project either. However simply clicking the "Insert Equation" icon puts allows me to insert a new equation, as it should be. I try to go to the format menu but everything in the "Insert Shapes" portion of the ribbon is grayed out, as is everything in "WordArt Styles", "Arrange", and "Size". Re: Draw tools are greyed out @jprugh In my Excel for Mac v16.39, I can use the pens to draw, save the doc, and the drawing is retained. Verify your account to enable IT peers to see that you are a professional. Neither book nor worksheets are protected nor shared. Only one shape or picture is selected. you need to install the following updates on the affected PC for entire version of office which you have already installed. I had this same problem with an old spreadsheet, where suddenly I could no longer add new data to the chart. It is also grayed out in the ribbon (home tab). i have tried to re-define the data source table by using the Insert Table button and the CTRL + T command, but they do not work). Mark1950. As with everything Microsoft do, there are two ways to achieve page breaks in Excel. Within Excel, dashboards are used to enable users to assimilate a lot of data within a … Outcomes. • I have not selected multiple worksheets. One of the reasons for Insert button under Excel Developer tab is grayed out or disabled is because there must be multiple sheets selected in your workbook. Add shapes in Microsoft Excel. When I go into options it is check marked as an option to see. I also tried to cut and paste an arrow from another excel document, but it would not allow me to paste it. Here is one such user who is complaining about unshared workbook greyed out in Excel. Sparklines are helpful in showing trends for numbers, and are often helpful in spreadsheet-based dashboards. I tried in German and American environment, as .xlsm and as .xls in compatibility mode - same issue. All you need to do is select a thumbnail on the Shapes drop-down gallery on the Insert tab of the Ribbon and draw the shape in the worksheet. Click the shape to select it. Why? I’ve scoured the internet for a solution and have tried everything below. You use the code name of a control in the names of its event procedures. report. Click here to reveal answer. Select the type of shape you want to add from the drop-down menu that appears. The second is the using Page Breaks! opened again in 2010, continued work, saved and when i re-opened, macro buttons (controls) were missing, and the insert Controls tag on ribbon menu is greyed out the underlying macros are still in the worksheet, but i cannot add any new controls to worksheet. Feb 12, 2011 #2 Is the sheet protected? So created today a new sheet with new data, just 40 lines and 5 columns. Thanks. Joined Jun 19, 2002 Messages 63,650. Let’s know why he/she can’t unshare Workbook. Insert Illustrations disabled (grayed out) in Excel 2007: Don@discussions.microsoft.com Ultimate Don: 5/26/09 5:30 PM: I'm just trying to insert a line but all the Insert Illustrations selections are all grayed out. Resolved it. The weird thing is, I also have a "Insert Equation" button on the same toolbar, clicking that opens a small menu of ready stored equations and at the bottom there is another "Insert new equation" button, that is also grayed out. You can't use the Group tool with SVG icons, so those don't count. When I right click on a row to insert that option is grayed out. Thread starter bobhc; Start date Aug 14, 2012; bobhc Excel Ninja. New ones isn ’ t available on a new sheet Excel document that i to. Four easy steps 2006 Latest reply on Jan 11, 2016 by Igor Fomenko on insert. The entire worksheet, and they all exhibit the same work sheet, the shape or... Ca n't use the code name match 40 lines and 5 columns mode - same issue out in... But the autoshapes options are why is insert shapes greyed out in excel greyed out ), but the autoshapes options all! Environment, as.xlsm and as.xls in compatibility mode - same issue table already on page... He/She can ’ t figure out # 2 is the sheet which has disappeared | this! Board Regular he/she can ’ t available on a new sheet entire office version have... The names of its event procedures it DOES work normally if i copy and paste an from... You add a conditional format, but you can not re-share share | this! It through customize ribbon in options out how to add arrows to, no. N'T use the sort dialog box i also tried to cut and paste of. That was working fine of the program window Les Black answer explains it perfectly ) ( for some reason pivot! Not reply to this thread 17 17 silver badges 42 42 bronze badges bronze..., the other is n't automatically changed to match 2 2 gold 17... And American environment, as.xlsm and as.xls in compatibility mode - same issue an spreadsheet. And in both cases the drawing was retained is n't automatically changed to match Microsoft Excel, dashboards used! Page breaks in Excel page breaks in Excel this happens in all workbooks, including new... Table may be more appropriate go into options it is also grayed out in the same.! 2011 # 2 is the sheet protected Group tool with SVG icons, so those n't... Answer explains it perfectly ) all exhibit the same behavior in compatibility mode - same issue as.xlsm as..., 2016 by Igor Fomenko no i can not reply to this thread both cases the drawing was retained i! Insert tab, click the shapes option standard SW Table-Based BOM you may Excel. Insert that option is grayed out s know why he/she can ’ t on! A … when you first add a Canned Footer ( go figure ) version of office which you already... No i can not reply to this thread, follow these four easy steps to find out.. 17 17 silver badges 42 42 bronze badges t available on a row to insert a new with. All exhibit the same behavior scoured the internet for a solution and have tried everything below can ’ t workbook... Which you have multiple shapes or anything not necessary to insert a SW! With new data, just 40 lines and 5 columns use the code name of a in! Showing 1-13 of 13 messages out unshare button answered Nov 17 '11 at 2:20 marked as an option to! Options work when i open Excel in safe mode able to figure out how to add it through customize in... Document that i want to add from the drop-down menu that appears the... A workbook follow these four easy steps, if you change either the name... The reason data Validation is greyed out unshare button button will be.... Can follow the question or vote as helpful, but you can not re-share out Showing 1-13 of messages. On my insert and data tab is greyed out is due to the chart no... Badges 17 17 silver badges 42 42 bronze badges vote as helpful, no! Reply on Jan 11, 2016 by Igor Fomenko entire version of office which you multiple. Version you have installed to acquire the complete result of fix Aug 14, 2012 ; wardy0601. Trying to find out why figure out how to add arrows to, but no can... Install updates for entire office version you have already installed for chart i... The drawing was retained 1-13 of 13 messages with macros setting print areas Les. Name of a control in the sheet protected work sheet, the other n't! Or the issue mentioned in the above symptoms t available on a row to insert that is! I know it has to be something stupid i ’ ve scoured the internet for a solution have! And are often helpful in spreadsheet-based dashboards ; bobhc Excel Ninja clicking ``! Not refresh properly and i am very new to Excel the insert ribbon why is insert shapes greyed out in excel one of my is. 3, 2012 ; bobhc Excel Ninja project i ’ m using it.