greyed

  1. D

    Excel tab menu options some greyed out?

    Hi I have a work book with many tabs, Excell 2019 the book or tabs sheets are not protected. The menu options (all except 3 of) in the tab menus are greyed out. Can anyone assist as to why this is? Note it is only this one workbook as with other workbooks it does not apply. Regards
  2. szita2000

    I'm in trouble all tabs missing, ribbon greyed out

    Hi Guys. I am in major trouble. This morning one of the files I made seems to be broken. When I load the file (xlsm) with or without macros enabled, All the tabs are missing and the whole ribbon is greyed out. When I go to the VBA editor, I can see the worksheets, the modules and all...
  3. R

    No Share workbook in the review tab - protect group

    Hi , I can see only 'unshare workbook' which is greyed , how to get it to 'share'. I am unable to fix it going to the options
  4. J

    Form Control Grouping Greyed Out

    Hi all, I'm creating a set of checkboxes for a multi-series chart so users can select which series to display. I'm trying to group them into a groupbox but the option is greyed out/disabled: I can create the Group Box via the Insert option on the Developer Tab I can create and format my...
  5. S

    Connection Properties - Refresh on Open greyed out.

    Wanting data source to refesh on opening Workbook however most of the options are greyed out. In particular "Refresh data when opening the file" Any advice appreciated.
  6. P

    Macros disabled - Greyed out in Trust Settings - Can't turn it back on

    I was writing a program and got hung in a loop, so I ended Excel through Task Manager and now I'm getting the message "Because of your security setting, macros have been disabled." I tried going into the Trust Center to re-enable macros, but all the options are greyed out and I can't select...
  7. A

    Draw tool greyed out

    Hello, I noticed that when I'm using "Freeze Pane", my Draw tool becomes greyed out. Is there a workaround? Thanks! Anita
  8. M

    Excel New Charts - Paste Link greyed out

    Hi, Copying waterfall chart created in Excel 2016 to PPT. I have embedded previously but now am asked to Paste Link - didnt know this chart type has that option greyed out. Any workarounds? or is this a known bug? Thanks in advance, MikeL
  9. T

    Slicer button Greyed out

    Using an (.xlsx) file. Excel 2016 I want to insert a slicer into a regular table, however for the entire workbook, the slicer button is greyed out. Tried saving the file under a new name, but the button is still greyed out. When i copy and paste the table into a new file, the slicer button is...
  10. Caleeco

    Pivot Table Slicers - Only Display Items with values?

    Hello, I'm not sure if this is possible in Excel, but I would find it very useful if it is! When using multiple slicers, often you'll end up with greyed out slicer buttons where data isnt available for the current filtered data. Is there a way to prevent these 'greyed out' options from even...
  11. R

    ICONS in Developer Ribbon is Greyed Out

    Hello All, I am using OFFICE 2016 Professional. After running one macro, My Icons on Developer Tool Bar is greyed Out. I am not able to either edit / run any macros. Can anyone help in fixing the same. Regards Sudhakar R
  12. H

    Graph template save as greyed out

    I have received a spreadsheet with several graphs. I have tried to create a template for some of these but right clicking on one of the charts and choosing save as template, but the "Save as Templete" is greyed out I would like know how to enable this. I have checked and the sheet is not...
  13. I

    Insert button greyed out

    Morning all, In a workbook i have 6 worksheets. The worksheet i am working on ive noticed the insert button is greyed out. Look at the other worksheets 3 are ok but 3 are greyed out. Can you advise please
  14. H

    Tab Color Greyed Out

    When right clicking any sheet, the Tab Color as well as Hide , Unhide etc is greyed out. Not sure why as sheets and workbook are unprotected It would be appreciated if someone can advise on how to resolve this
  15. C

    Inserting rows on protected sheet

    Hi Is there any way round this? Right click and format cells is greyed out... Any help most appreciated! Thanks Catherine
  16. L

    enable cutcopy

    Hi good people!, my friend's pc just suddenly gave a problem. He was opening files and everything worked, until he opened another. Cut, Copy, Paste, Delete, "drag and drop", everything is greyed out. I wrote the "application cutcopymode=true" in the workbook beforeclose event, but even with...
  17. N

    Slicer connection options greyed out

    HI, When inserting a slicer from a table, the option to select report connections is greyed out. My worksheets are not protected. Thank you, apologies if this is a simple one.... UPDATE This only happens when inserting a slicer from a table, not a pivot table
  18. S

    Create a Refreshable Listobject via VBA

    Hi All, I am able to select data out of my SQL server database into a ListOjbect via VBA. My problem is I cannot make the ListOjbect Refresh. Meaning I would like to be able to select the list object in Excel and right click and choose refresh (currently grayed out) or refresh it via VBA...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top