Hi,

I have a workbook that I had been using for over a year with a very simple formatting macro in it.  As of about two weeks ago, adding new data to the spreadsheet causes Excel to crash, rendering the workbook as corrupt.  I have started fresh with a new workbook and re-recorded the macro at least a dozen times, and it will run once - maybe twice - and then, when new data is put into the workbook, it crashes.  The weird thing is, I have anothe workbook that also has a simple formatting macro in it and that one runs fine.  Both worksheets get the data from the same source, which is copied and pasted into the workbook with the macro.

Any ideas?????

Thanks!

Nancy

Hi,

Have you tried some general steps to troubleshoot this issue? For example, Repair Office. If not, please try this KB and check if they are helpful:

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

If this issue still exists, we need to collect the event log to do further troubleshoot.

Steps: Open Event Viewer to check whether there's any error about the Excel/Word crash issue.

Press Win + R, type "eventvwr" in the blank box, press Enter. In the Event Viewer, browse to Windows Logs -> Application, there may be some errors after the crash.

To protect your privacy, you may send the error logs to ibsofc@microsoft.com, we will try to find the cause.

Regards,

George Zhao
TechNet Community Support