I've recently upgraded to Win7 and Office 2010 on a new, robust desktop PC. I have a moderately complex workbook that was build up in Excel 2007. File is about 1GB, with some embedded charts etc. There are a number of LOOKUPs in the primary worksheet.
It was fairly stable in Excel 2007.
Ever since the upgrade I've had repeated issues with Excel freezing and crashing. The problem seems most acute when I try to Insert a Row in the middle of a worksheet, which I usually do using COPY > INSERT COPIED CELLS.
I'm experiencing the same problem with some other workbooks, but to a much lesser degree. But this particular function seems to take a long time on all workbooks.
Is there a general stability problem here, and any suggestion on how to pinpoint the cause of the problem?