In MS Excel Insert,Paste Special option showing Disable / Grayed

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

1. Close all open Microsoft Excel files
2. Go to Run command prompt (Press Windows + R) / type run on search box you will get following screen.
   
3. After above process you 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.