Greetings!
This is my first time posting in this forum. I have already said a silent prayer that assistance to my particular problem may be found here.
Well, as the title states, I have an Excel 2010 workbook and, on one of the sheets, whenever I attempt to type in a cell, Excel crashes. I have never heard of such an annoying symptom before (I admit my irritation is heightened a bit due to the fact that about 10 analysts are depending on me to finish a user friendly app ASAP.
Specs:
> 15 sheets in the spreadsheet. Current size is 127 kb
> has a userform with 13 tabs in a multipage userform
> each sheet has at most 120 rows, and at most 15 columns
> probably 110 defined names or so
> sheet uses Excel vba (in the userform) and runs light sql statements when the form is loaded
If you would like to see the behavior in action, open the attached ICRP_dev_v4.xlsm in Excel 2010 and, in the sheet entitled ReviewerNoteResize, attempt to enter values anywhere in the A103:E110 range. You will (if you're like me) encounter Excel crashing for no apparent reason.
Tried but results unsuccessful:
> Searched the forum looking for answers - no joy
> Did a File Open, then selected Open and Repair, and chose the repair option - still didn't correct problem.
> Error was occurring on my notebook computer. I then tried the spreadsheet on my desktop PC - same crashing annoyance.
Thanks in advance for any assistance you can offer!
Regards,
- Dave,
Bookmarks