I realize this is really vague, but I thought it would be best to keep this as simple as possible as I first pose this question ...

Has anyone had repeated experience with Excel 2007 crashing and upon restarting, get a message that Excel found unreadable content in a workbook with a prompt to recover it--and then after asking to recover, get a message saying it can't be recovered because it is corrupt?

This happens to me fairly frequently. It does tend to happen more often when I'm working on an Excel project with a large amount of complex functions and/or VBA code. Currently though; I've been working on a project for someone else and initially was reusing the same workbook that has been in use for this application for a few years (is pretty huge--more than 100 sheets). Yesterday it crashed on me, prompted to recover and said it couldn't because it was corrupted. Since this workbook could have picked up who knows what over time, I started over with a fresh workbook, and when moving data and content from the old workbook to the new workbook I have been copying data only (paste special).

Right now I have only a few sheets and little data moved in, and a handful of VBA code, and it crashed on me when moving a cell (a merged cell that was originally 1x4)


I'm hoping to try and pinpoint if maybe it's my excel installation or not. Below is all of the code I have in the project right now. Currently there are no functions in the project that aren't in a VBA module. I have ten of the worksheets setup with tab names only (no data), and there is really only one sheet with data right now and it isn't much. Can't figure out why the workbook is getting corrupted...

Module 1:
Please Login or Register  to view this content.
Module 2:
Please Login or Register  to view this content.
Module 3:
Please Login or Register  to view this content.
Module 4:
Please Login or Register  to view this content.

Any thoughts and ideas are welcome...thanks!