Excel Insert / Paste Special option showing Disable / Greyed

  1. Close all open excel files
  2. Go to Run command prompt (press Windows + R) / type run on search box you will get following screen.
    ex12
  3. After above process you will get following screen type %appdata%\Microsoft\Excel press Enter
    ex13

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s