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

Excel showing Grayed

Rename Excel15.xlb ==> Excel15.old

Now open excel files you all function will work perfectly.

Dive in!

Join 10001 others, and start your Knowledge journey with us today.

We promise we’ll never spam! Take a look at our Privacy Policy for more info.