Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel macro in 2007 runs extremely slow
I have this macro that typically ran from 12-15 minutes in Excel 2003. There
is alot of computations, and moving data(small data) around. On a similar PC it takes about 60-70 minutes when it runs on Excel 2007 with SP1. Other smaller macros take about the same time in both Excel 2003 & Excel 2007. This has me perplexed. Any ideas ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel macro in 2007 runs extremely slow
Tell Microsoft about it:
http://blogs.msdn.com/excel/archive/...requested.aspx - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Acie" wrote in message ... I have this macro that typically ran from 12-15 minutes in Excel 2003. There is alot of computations, and moving data(small data) around. On a similar PC it takes about 60-70 minutes when it runs on Excel 2007 with SP1. Other smaller macros take about the same time in both Excel 2003 & Excel 2007. This has me perplexed. Any ideas ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel macro in 2007 runs extremely slow
As someone else noted recently (with sly grin on their face), the apparent
difference in performance of 2007 vs 2003 is a 'feature' of 2007. You're probably going to need to look hard at your code and what it is doing, and how it is doing it to get performance improvement. However, one thing that can improve performance dramatically is the simple inclusion of the Application.ScreenUpdating=FALSE statement near the beginning of your macro code. That keeps the sheets displayed from having to be refreshed with each new calculation/data move, or when you jump around in the workbook via sheetName.Activate in your code. You might take a look at www.DecisionModels.com for other helpful hints. "Acie" wrote: I have this macro that typically ran from 12-15 minutes in Excel 2003. There is alot of computations, and moving data(small data) around. On a similar PC it takes about 60-70 minutes when it runs on Excel 2007 with SP1. Other smaller macros take about the same time in both Excel 2003 & Excel 2007. This has me perplexed. Any ideas ? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel macro in 2007 runs extremely slow
I tried adding the statement Application.ScreenUpdating=FALSE
to my two Macros. There was an improvement. Adding a single cell reference formula now only takes 1:45 instead of 3 minutes. See my other posts under "Excell 2007 - Slow &can;t run macros" of 3/1/2009 "JLatham" wrote: As someone else noted recently (with sly grin on their face), the apparent difference in performance of 2007 vs 2003 is a 'feature' of 2007. You're probably going to need to look hard at your code and what it is doing, and how it is doing it to get performance improvement. However, one thing that can improve performance dramatically is the simple inclusion of the Application.ScreenUpdating=FALSE statement near the beginning of your macro code. That keeps the sheets displayed from having to be refreshed with each new calculation/data move, or when you jump around in the workbook via sheetName.Activate in your code. You might take a look at www.DecisionModels.com for other helpful hints. "Acie" wrote: I have this macro that typically ran from 12-15 minutes in Excel 2003. There is alot of computations, and moving data(small data) around. On a similar PC it takes about 60-70 minutes when it runs on Excel 2007 with SP1. Other smaller macros take about the same time in both Excel 2003 & Excel 2007. This has me perplexed. Any ideas ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extremely slow subtotals in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel extremely slow opening | Setting up and Configuration of Excel | |||
Excel and Word EXTREMELY slow to open | Excel Discussion (Misc queries) | |||
Office 2000 Excel Macro runs very slow in 2003, why? | Excel Discussion (Misc queries) | |||
Excel extremely slow opening and using | Excel Discussion (Misc queries) |