greyed

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

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...

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

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...

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.

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...

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

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

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...

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...

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

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...

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

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

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

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...

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

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...