I just upgraded my computer due to speed issues (Windows XP to 2007). With this upgrade my company gave me excel 2010, from excel 2007. I have a macro enabled workbook that has quite a bit of calculations/conditional formatting. The issue is that it was running just fine with Excel 2007, but now I can't even insert/remove a single cell without waiting 1 minute. Then after I try to close the spreadsheet a dialog box states "Excel cannot complete this task with available resources. Choose less data or close other applications" Continue without Undo?
Any ideas what I can do?