Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #41   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8,520
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9,101
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,582
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 230
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,440
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.programming
KSR KSR is offline
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I speed up excel 2007 louis Excel Discussion (Misc queries) 1 May 7th 09 12:55 PM
Analysis Toolpack Issues in Excel 2007 (Office 2007 Enterprise) Ben Shields Excel Discussion (Misc queries) 2 February 24th 09 06:04 PM
Speed VBA Excel 2003 vs 2007 blue7hand Excel Programming 2 June 10th 06 05:53 AM
Speed issues Antonio Excel Worksheet Functions 4 May 8th 06 08:23 AM
Speed Issues again Jase Excel Programming 1 November 11th 03 05:34 PM


All times are GMT +1. The time now is 04:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"