Inserting a new line crashes my program after attempting to update my formula

[Googlesoar]

I have a formula on Sheet1 that goes "='Sheet2'!I10", when I go to Sheet2 and insert a new line beneath I10, so I am clicking on the whole row of I11 and inserting a line, the formula in Sheet1 still reads "='Sheet2'!I10". Cool , great, that seems ok, but the moment that I click on the formula and do nothing but click on the check mark the entire program crashes with this report error.
WHY! It was working the other day and now it's not. This is on a sheet with no macros and it never had macros. On previous sheets I had macros that would turn xlCalcAuto on and off but would always leave it on at the end, I did this just for a quicker run time. This happens to all new workbooks that I open as well.

Problem Event Name: APPCRASH
Application Name: Excel.EXE
Application Version: 14.0.7179.5000
Application Timestamp: 58a5e2fb
Fault Module Name: EXCEL.EXE
Fault Module Version: 14.0.7179.5000
Fault Module Timestamp: 58a5e2fb
Exception Code: c0000005
Exception Offset: 00261b14
OS Version: 6.1.7601.2.1.0.256.48
Locale ID: 1033

[dflak]

Whatever is causing the crash, it probably isn't VBA or a macro. They don't produce errors like that. I suggest you do a web search on "MS Office Repair." Excel might be "stepping on a bad spot" on the disk and repair might clean it up. You should not need the media to do a repair.

[Googlesoar]

Thank you for the reply

[Googlesoar]

Whatever is causing the crash, it probably isn't VBA or a macro. They don't produce errors like that. I suggest you do a web search on "MS Office Repair." Excel might be "stepping on a bad spot" on the disk and repair might clean it up. You should not need the media to do a repair.

Do you believe this would happen to a users computer using my Spreadsheet. Do you have any idea as to why one day it would work fine and the next it would "Step on the bad spot"

I'm sorry for the late response it's just I am working on a company computer and I actually can't seem to repair Excel on my own without IT support.

[dflak]

I really don't know what is happening. I am speculating as to what might be going on. The issue does seem to be with the Excel executable rather than code within the executable. Does the code crash on other computers? Perhaps it is time to file that help desk ticket with your IT support team.