Excel crashes when using "Insert Function

Question

When I open an Excel Spreadsheet (new or existing) I can enter data into the first cell (A1 for example), and then I hit return and when I try and enter data into the second cell (A2) it crashes.  I was able to discover several things. 

1.  After entering something into A1 and hitting return, when I put my cursor into the formula bar, the cursor does not blink.  If I hit a return, it crashes.  If I click the check mark (enter) and then try to enter something, it works.  If I put my cursor into another cell (b2, for example), and then back to A1, it works.  If I click the insert function (next to the formula bar) or the insert function icon at the top, it crashes.  I am using Office 10, running Windows 7, 64 bit.  I have spent hours on this and although the workaround works, it is totally unnecessary. I've tried repairing Office.

Answer 1

Hi,

Let me assist you with the issue.

This issue may occur due to several reasons. Let us start with opening Excel in safe mode. To do that, follow the steps below.

Hold the Windows key and press R, type excel /safe (note there is a space between excel and /).

If the application works fine safe mode, try disabling the add ins for the application and check the result,

Click the File tab.

Go to Options.

Click Add-ins.

Clear all the options.

If that does not help, then follow additional troubleshooting steps mentioned in the following article:

http://support.microsoft.com/kb/280504/en-us

Disclaimer: Important this section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make

sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry.

Follow these steps to back up the registry.

http://windows.microsoft.com/en-us/windows/back-up-registry#1TC=windows-7

Let us know if the suggestion provided is helpful.

Thank you.