One of my friends reported me that he is able to ‘Cut’ and ‘Copy’ using Ribbon buttons and Ctrl-X and Ctrl-C as usual but when he Right clicks on any cell ‘Cut’ and ‘Copy’ options are disabled in shortcut menu. But if used Ctrl-C, Paste option is available on shortcut menu.
Whereas these options are working well with other MS-Office files.
Following is the solution that I worked out and provided to the user and it solved the problem:
- Close Excel
- Open My Computer
- Go to folder ‘C:\Users\username\AppData\Roaming\Microsoft\Excel’. (AppData folder is hidden by default)
- Rename Excel14.xlb and Excel15.xlb
- Open Excel and Check