Sometimes we face such issues like few options in Ms excel not working properly. One of them is here we are solving for you.
How to Resolve Disable /Grayed options in Excel
Steps to resolve grayed options of Ms excel
- Close all open Microsoft Excel files
to Runcommand prompt (Press Windows + R) / type run on search box you will get followingscreen.
above processyou will get following screen type %appdata%\Microsoft\Excel press Enter
On screen you will find a file with name Excel15.xlb
Rename Excel15.xlb ==> Excel15.old
Now open excel files you all function will work perfectly.