Excel - right click opens another spreadsheet

Question

Hi all,

I really need your hope - I tried everything and Im close to give up :-( Im working in a normal Excel file (not a macro file) and when I do a right click->rows (I want to insert the whole row). For some reason it opens another Excel file that is not even open currently.

Feels like for some reason there is a command assign to right click-rows but I cannot trace it. It is now a macro file so there is no macro running in the backgroud also.

Any ideas how to fix it, it's extemaly annoying.

Looking forward to back from you,

Excel.wizz

Answer 1

First thing to try is to use Excel in Safe mode - hold down Ctrl while launching Excel.  That prevents add-ins and startup programs from being loaded.

Now try the right-clicking operation that was misbehaving.

a) If it doesn't happen then the problem is caused by some add-in or a workbook that is loaded on startup.  Disable all add-ins ( File > Options > Add-Ins ). 

Move any files from your XLSTART folders.

• They vary according to username, Excel version and Windows version.
• From the immediate window of the VB editor you can find those folders by:

 - ?Application.StartupPath

 - ?Application.Path     ' and then add \XLSTART to the result

 - ?Application.AltStartupPath  ' corresponds to File > Options > Advanced > General > At startup, open all files in

You can then add things you need back in one at a time, repeating your test each time and so discover which is causing the problem.

b) If it still happens in Safe Mode, try doing a repair from Control Panel > Programs and Features > Microsoft Office > Change > Repair.

c) If it still happens, try

Alt+F11 to VB editor

Ctrl+G to immediate window, and type

Application.CommandBars("Row").Reset

and hit the Enter key

Answer 2

Hi Bill,

Thank you so much! I tried the safe mode and that didnt work but the option "c" saved me :-)

Much appreciated!