P
Peige Chang
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?
progress on getting a fix on the slow Excel issue?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jacob Skaria
I am not sure whether this article would help...
http://msdn.microsoft.com/en-us/library/aa730921.aspx
If this post helps click Yes
http://msdn.microsoft.com/en-us/library/aa730921.aspx
If this post helps click Yes
J
Joel
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.
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.
J
Jon Peltier
They followed up with
Excel VBA Performance Coding Best Practices
http://blogs.msdn.com/excel/archive/2009/03/12/excel-vba-performance-coding-best-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
Excel VBA Performance Coding Best Practices
http://blogs.msdn.com/excel/archive/2009/03/12/excel-vba-performance-coding-best-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
C
Catalin Florean
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.
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.
M
Martin Brown
Catalin said: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
N
Niek Otten
Do you happen to lookup values in whole columns?
J
Jamshid Faryar
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?
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?
K
KSR
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.
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.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.