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