Excel 3.0 spreadsheet opens then clocks continuously
Posted on 2013-01-16
Hope you can help me. I'm making changes to a VBA-driven spreadsheet in Excel 3.0. OS is Windows 7. Had to stay with Office 3.0 for compatibility with other systems. I've finished the spreadsheet and am testing the VBA code. I made a change to the code, saved the spreadsheet and closed out iof it momentarily. When I opened the spreadsheet back up, it just sits there clocking - It won't let me access any of the cells. I can't stop it from clocking by using CTL + Break or Esc. The only way to stop it is to shut Excel down completely. I don't kno why it's doing this. It's small by spreadsheet standards: 2,734K.
Can anybody tell me why this might have happened and what I might be able to do to re-access this spreadsheet?