Home |
Search |
Today's Posts |
#41
Posted to microsoft.public.excel.programming
|
|||
|
|||
More Excel 2007 Speed Issues
I am not sure whether this article would help...
http://msdn.microsoft.com/en-us/library/aa730921.aspx If this post helps click Yes -------------- Jacob Skaria "Peige Chang" wrote: I noticed that the last time Wei posted was 5/2007. Has there been any progress on getting a fix on the slow Excel issue? *** Sent via Developersdex http://www.developersdex.com *** |
#42
Posted to microsoft.public.excel.programming
|
|||
|
|||
More Excel 2007 Speed Issues
Microsoft made a posting on Dec 28. 2008 (or around this date) in the Excel
Programming webpage asking for people to submit macros/workbooks where the macros ran slower on excel 2008 than excel 2003. Microsoft said they had a team together to investigate these issues. I refered a number of people to that posting. "Jacob Skaria" wrote: I am not sure whether this article would help... http://msdn.microsoft.com/en-us/library/aa730921.aspx If this post helps click Yes -------------- Jacob Skaria "Peige Chang" wrote: I noticed that the last time Wei posted was 5/2007. Has there been any progress on getting a fix on the slow Excel issue? *** Sent via Developersdex http://www.developersdex.com *** |
#43
Posted to microsoft.public.excel.programming
|
|||
|
|||
More Excel 2007 Speed Issues
They followed up with
Excel VBA Performance Coding Best Practices http://blogs.msdn.com/excel/archive/...practices.aspx This article had nothing new about Excel 2007 performance, but it contained a long list of known techniques to enhance VBA execution speed. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Joel" wrote in message ... Microsoft made a posting on Dec 28. 2008 (or around this date) in the Excel Programming webpage asking for people to submit macros/workbooks where the macros ran slower on excel 2008 than excel 2003. Microsoft said they had a team together to investigate these issues. I refered a number of people to that posting. "Jacob Skaria" wrote: I am not sure whether this article would help... http://msdn.microsoft.com/en-us/library/aa730921.aspx If this post helps click Yes -------------- Jacob Skaria "Peige Chang" wrote: I noticed that the last time Wei posted was 5/2007. Has there been any progress on getting a fix on the slow Excel issue? *** Sent via Developersdex http://www.developersdex.com *** |
#44
Posted to microsoft.public.excel.programming
|
|||
|
|||
More Excel 2007 Speed Issues
Hi All,
This is a very old thread, but I just upgraded my users from Office 2003 to 2007. Almost immediately then Excel slow performance became a big problem. We have hundreds of excel files, based on the same empty template, used at work. Under 2003 everything worked OK. In 2007 a "page down" will take 10-15 second to scroll. This is what I've done to improve: 1. Excel Options - Advanced - Disabled "Enable multi-threaded calculation" Even with dual-core computers Excel works faster if this option is disabled. 2. Using OpenOffice 3.1 I opended existing excel file and saved it as MS Office 2003 format. The resulting file was half the size and when I open it with Office 2007 the speed improvements are just fantastic. For info, at work we all have the same HP dual core laptops with 2GB RAM, XP Pro and Office 2007 pro. Catalin. *** Sent via Developersdex http://www.developersdex.com *** |
#45
Posted to microsoft.public.excel.programming
|
|||
|
|||
More Excel 2007 Speed Issues
Catalin Florean wrote:
Hi All, This is a very old thread, but I just upgraded my users from Office 2003 to 2007. Almost immediately then Excel slow performance became a big problem. We have hundreds of excel files, based on the same empty template, used at work. Under 2003 everything worked OK. In 2007 a "page down" will take 10-15 second to scroll. It is only certain things or more commonly unfortunate combinations of things that cripple its performance. It would be worth looking to see what is special about this spreadsheet that causes this slowness. Lots of graphs is the main one that I find to be a problem. YMMV This is what I've done to improve: 1. Excel Options - Advanced - Disabled "Enable multi-threaded calculation" Even with dual-core computers Excel works faster if this option is disabled. That is a bit surprising. 2. Using OpenOffice 3.1 I opended existing excel file and saved it as MS Office 2003 format. The resulting file was half the size and when I open it with Office 2007 the speed improvements are just fantastic. Do you not get the same benefit opening the file in compatibility mode as saved with XL2003? For info, at work we all have the same HP dual core laptops with 2GB RAM, XP Pro and Office 2007 pro. It is worth applying the various service packs too. Some things are a bit better in SP3. It still isn't what you would call quick. Regards, Martin Brown |
#46
Posted to microsoft.public.excel.programming
|
|||
|
|||
More Excel 2007 Speed Issues
Do you happen to lookup values in whole columns?
-- Kind regards, Niek Otten Microsoft MVP - Excel "Catalin Florean" wrote in message ... Hi All, This is a very old thread, but I just upgraded my users from Office 2003 to 2007. Almost immediately then Excel slow performance became a big problem. We have hundreds of excel files, based on the same empty template, used at work. Under 2003 everything worked OK. In 2007 a "page down" will take 10-15 second to scroll. This is what I've done to improve: 1. Excel Options - Advanced - Disabled "Enable multi-threaded calculation" Even with dual-core computers Excel works faster if this option is disabled. 2. Using OpenOffice 3.1 I opended existing excel file and saved it as MS Office 2003 format. The resulting file was half the size and when I open it with Office 2007 the speed improvements are just fantastic. For info, at work we all have the same HP dual core laptops with 2GB RAM, XP Pro and Office 2007 pro. Catalin. *** Sent via Developersdex http://www.developersdex.com *** |
#47
Posted to microsoft.public.excel.programming
|
|||
|
|||
More Excel 2007 Speed Issues
The problem is not related to the size and complexity of a
spreadsheet, and the problem is easily fixed by copying into a new spreadsheet of the same size and complexity. Whatever is causing the problem is "dropped" when the spreadsheet is refreshed in a new copy: the performance improves and the size of the file is reduced. Is there an internal log of the changes made to a spreadsheet that is dropped when the spreadsheet is refreshed into a new copy? *** Sent via Developersdex http://www.developersdex.com *** |
#48
Posted to microsoft.public.excel.programming
|
|||
|
|||
More Excel 2007 Speed Issues
I have an Excel workbook with 7 report worksheets, each generated by
pressing its appropriate button on one data worksheet. There are 12 supporting data worksheets, for a total of 19 worksheets. 6 of the report worksheets contain images and textboxes that bring in cell values from other data worksheets, i.e. using =worksheetName!C1, etc. One report is simply 2 worksheets of cells, i.e. no images or textboxes. This one report, when run in 2003 runs in 2 seconds. In 2007 it takes 1 min 45 secs. There are 26 rows of data used to generate the report. It appears that it is the textboxes on the other 6 reports that are slowing down the report generation process...determined this by removing the image/textbox report worksheets and confirming by simply removing the textboxes from the same worksheets. With those 2 trials the report ran in 7 seconds. I was hoping that by changing to manual re-calculation using VBA, it would exclude the textboxes on the other worksheets, but that did not work. I'm thinking that somehow the textboxes need to be prevented from being re-evaluated and from being refreshed on the 6 reports that are not being regenerated when this one is. Does anyone know if my evaluation is flawed or if there is a way to prevent textboxes on other worksheets from being refreshed? Great contributions here on the slowness of Excel 2007. My situation seems to be somewhat related, yet unique. *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I speed up excel 2007 | Excel Discussion (Misc queries) | |||
Analysis Toolpack Issues in Excel 2007 (Office 2007 Enterprise) | Excel Discussion (Misc queries) | |||
Speed VBA Excel 2003 vs 2007 | Excel Programming | |||
Speed issues | Excel Worksheet Functions | |||
Speed Issues again | Excel Programming |