Excel 2010 worksheet is operating slow. It says "not responding". Lately, it shuts itself down but when it boots up it still operates slowly. I copied the worksheet to a flash drive and tried it in my wife's laptop and it did the same so I suspect it has something to do with the worksheet itself.
Try turning OFF auto calculation. On the Ribbon,
Select Formulas
Select Calculation Options
Check ManualThen load your workbook and see if that speeds things up.
Mike Thank you for taking the time to help me out. It didn't help solve the problem but I noticed that my spreadsheet was saving in excel 2007 mode but I updated to excel 2010. Somehow , I was able to get the spreadsheet saved to excel 2010 mode and it seems to be working better.
Have a merry Christmas.
Arnie
Ad Choices