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.

close

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.