Most of the option in Excel workbook is grayed out.
Under Insert Tab> all the groups like; Tables, Illustrations, Add-Ins, Charts, Tours are grayed out.
Does anyone know the solution?
I am using office365 on Windows10
Hi @Jimmypop
Thank you for your comment
My problem is not about what you are pointing out.
My problem is all the Insert tab which has been grayed out and not able to insert any shape.
Hi @Jimmypop
Thank you for your comment
My problem is not about what you are pointing out.
My problem is all the Insert tab which has been grayed out and not able to insert any shape.
1) You are editing a cell (or you are typing in the formula bar)
2) Your worksheet is protected
3) Your workbook is protected
4) Your worksheets are grouped (multiple sheets selected)
5) Objects are hidden (advanced display option)
6) You are sharing your workbook
7) You have tracked changes turned on
Hi @Jimmypop ,
Thank you for your comment.
I have tried online repair.
I have checked all the reason you have mentioned, But none of them are true in my case.
Then not sure what could be the issue... so I am guessing it does this when you open up a new workbook every time, does it do it on every file you open?
If possible maybe share the workbook with us via drive or dropbox... if it does not contain sensitive info... if it does then maybe should copy data to a new workbook and delete old one...
Hi @Jimmypop
I am so sorry. I found out the reason.
There was a sheet hidden which I was not aware of.
Someone who used this workbook before me has hidden it seems.
The problem is solved.
Thank you for your support.
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.