Find centralized, trusted content and collaborate around the technologies you use most. Connect and share knowledge within a single location that is structured and easy to search.

I found an Excel document on reddit that I am attempting to edit to suit my needs. I am having issues with it and went in to the options to change some settings. Everything is greyed out and cannot be changed. I have checked the file to make sure that it is not read only. I am as admin on the computer and, as far as I can see, have permissions for the file.

I have tried closing and reopening, as well as restarting the computer. Is there something obvious that I am missing? Or does anyone know how I can fix this so that I can keep editing the file? It probably means that you have grouped two or more sheets Be very careful.

Any change to one sheet impacts all grouped sheets deleting rows, entering values, etc. Select: Ungroup. Answer sourced here. The screenshot shows the general options for working with Excel, independent of any files. If you cannot edit a workbook, check if the workbook structure or the sheets are protected. All boxes are grayed out and look inaccessible, however they are still clickable and any changes made stay.

I was punked by Microsoft. I have this a lot, the problem is the show the preview pane where the file is saved. If the preview pane is showing the file, XL thinks its open so will not allow changes from menus. Click on another file or close the preview pane and it should be OK. Neither the cause of the issue nor the ‘simple’ correction has been discovered but all is now well.

In most cases you just need to unhide the worksheet , which was hidden by someone or due to a misconfiguration. If it was hidden, it will open up a dialog window asking to confirm the unhide action. This was tested here in Excel and Excel I had this issue. I didn’t realize that. I had the same issue, fixed by unchecking the option of share workbook allow changes by more than one user at the same time Stack Overflow for Teams — Start collaborating and sharing organizational knowledge. Create a free Team Why Teams?

Learn more about Teams. All Excel options are greyed out [closed] Ask Question. Asked 5 years, 11 months ago. Modified 1 year, 7 months ago. Viewed 95k times. Inessaria Inessaria 79 1 1 gold badge 2 2 silver badges 10 10 bronze badges. Add a comment. Sorted by: Reset to default. Highest score default Trending recent votes count more Date modified newest first Date created oldest first.

Select: Ungroup Once the last sheet is Ungrouped To Group sheets Developer Guy 2, 6 6 gold badges 18 18 silver badges 35 35 bronze badges. Mihai Mihai 21 2 2 bronze badges. Community Bot 1 1 1 silver badge.

Posted the first google result you could find, huh? The Tools menu disappeared with Excel , ten years ago. Is there a way to make the general Excel options changeable?

I need to change some things in there and am not sure why they are greyed out in the first place. I do notice that the options are greyed out in Word as well. I have Office , as downloaded from my college Office exchange email. Might that have something to do with it? Have you activated your copy of Office? If you can’t do anything with it, then the license may have expired. Maybe you just need to go online and authenticate with your college ID again, so Office knows it’s a legit install.

Or maybe your license has expired for eg if you no longer attend the college , in which case you can only read files, not change anything. I am still able to edit files with no issue, but everything in the options is greyed out.

It’s odd. What do you see on your accounts screen? Show 2 more comments. Stephen Hosken Stephen Hosken 1. Ok, the same issue occured, on all sheets, in a single workbook. This got around the issue. Closed workbook Made copy of workbook Changed name of original the one having issues Opened the workbook copy with original name Neither the cause of the issue nor the ‘simple’ correction has been discovered but all is now well.

ExpertNovice ExpertNovice 31 2 2 bronze badges. Mickie Davis Mickie Davis 1 1 1 bronze badge. Abdu Ki Abdu Ki 1. The Overflow Blog. Can you stop your open-source project from being used for evil? Related Hot Network Questions. Accept all cookies Customize settings.

 
 

 

– Options greyed out in tabs in word – Microsoft Community

 
Get your product registered, You were running a trial version and its expired. That’s why you are seeing all grayed out. Hello, We have an active Office license however it does not seem to be registering as the Advanced options are greyed out as in the attached picture. i am creating a Word Doc on a Mac and need to be able to insert multiple pictures and shapes. i have created a template (header.

 
 

Microsoft word 2016 options greyed out free

 
 
Yes No. Are those the grayed out options you are referring to? Threats include any threat of suicide, violence, or harm to another. Go to the Help menu and choose Check for Updates 3. Thanks for your feedback. Below are the pics that we have pulled.