Monday, 23 December 2013

Excel 2013 right click doesn't work in spreadsheet.

Problem:

Excel 2013 right click doesn't work in spreadsheet.

Solution:

Check if excel works in safe mode.
1. Hold Windows key + R.
2. Copy and paste, or type the following command in the Open box, and then press Enter:

Excel /safe

Note: There is space between Excel and /
If Excel safe works, disable the add-ins following steps mentioned below and determine the problem causing add-in: 

Try deleting following key from registry.

Excel 2007.
Go to regedit and delete Options entry from HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\ and verify the result.
Note:
• Hold Windows key + R.
• Copy and paste, or type the following command in the Open box, and then press Enter:
regedit

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options
right click on Options and delete it.

Note: Ensure to back up the registry before any modification or deletion.
a) Locate and click the key or subkey that you want to back up.
b) Click the File menu, and then click Export.
c) In the Save in box, select the location where you want to save the backup copy to, and then type a name for the backup file in the File name box.
d) Click Save.

Excel 2010.
Go to regedit and delete Options entry from HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\ and verify the result.
Note:
• Hold Windows key + R.
• Copy and paste, or type the following command in the Open box, and then press Enter:
regedit

HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options
right click on Options and delete it.

Note: Ensure to back up the registry before any modification or deletion.
a) Locate and click the key or subkey that you want to back up.
b) Click the File menu, and then click Export.
c) In the Save in box, select the location where you want to save the backup copy to, and then type a name for the backup file in the File name box.
d) Click Save.



Excel 2013.
Go to regedit and delete Options entry from HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Excel\ and verify the result.
Note:
• Hold Windows key + R.
• Copy and paste, or type the following command in the Open box, and then press Enter:
regedit

HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Excel\Options
right click on Options and delete it.

Note: Ensure to back up the registry before any modification or deletion.
a) Locate and click the key or subkey that you want to back up.
b) Click the File menu, and then click Export.
c) In the Save in box, select the location where you want to save the backup copy to, and then type a name for the backup file in the File name box.
d) Click Save.