extremely slow performance on macro enabled spreadsheet in Excel 2010 Windows 7

Question

After purchasing a new computer with 14GB Ram, quad core, Windows 7, and Office Home & Business 2010, I find that the performance is SO bad that I prefer to use my old computer with 1GB Ram, 1 processor, Windows XP and Office 2003 or 2007 (don't even specifically remember). The problem is the performance with the macro execution. It seems to me that any time there is a large quantity of data or when you are useing the Selection.Delete Shift:=xlUp or Selection.Delete Shift:=xlToLeft you'd better have an extreme amount of patience. There's got to be something causing this. Can anybody help? Thanks.

Answer 1

Angelo, I could write the same words for my identical situation. Have you found a solution, yet? I'm beginning my search for one. I have fabulous spreadsheets created in Office XP. I love Office XP! When I try to use these spreadsheets in later versions of Office from 2007 and beyond, my voluminous macros run so slowly. In earlier versions of Office, these same macros are super-fast. Also, only Windows 7 Ultimate allows for the same speed of my XP spreadsheets. Other versions of Windows 7 function with memory issues (32-bit spreadsheets operating in a 64-bit OS). I want to upgrade my spreadsheets to 64-bit, but my macros must work flawlessly and super-fast, or I'm not interested. Again, I'm still searching for the solution.

Answer 2

Thank you for the suggestion but, unfortunately, this did not make a difference. It did cause me to evaluate further and I notice that I also get extremely slow performance when executing someting as simple as:

            Selection.Cut

            ActiveCell.Offset(0, -1).Select

            ActiveSheet.Paste

            Application.CutCopyMode = False

            Calculate

If I watch the Task Manager while this is occurring I continue to see the Excel application flip back and forth between Running and Not Responding. Believe me, when I describe the performance as extremely slow there is no possible way to overemphasize "extremely".

Answer 3

After purchasing a new computer with 14GB Ram, quad core, Windows 7, and Office Home & Business 2010, I find that the performance is SO bad that I prefer to use my old computer with 1GB Ram, 1 processor, Windows XP and Office 2003 or 2007 (don't even specifically remember). The problem is the performance with the macro execution. It seems to me that any time there is a large quantity of data or when you are useing the Selection.Delete Shift:=xlUp or Selection.Delete Shift:=xlToLeft you'd better have an extreme amount of patience. There's got to be something causing this. Can anybody help? Thanks.

Use screen updating false before delete and change it later

Eg:-

Application.ScreenUpdating = false

Selection.Delete Shift:=xlUp

Application.ScreenUpdating = True