Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #21   Report Post  
Old November 5th 07, 02:22 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
Posts: 230
Default Pls confirm 2007 chart redraw is up to 10 times slower than 20

On Nov 5, 11:14 am, Steen T. wrote:
Hello

I have just upgraded from Office pro 2003 to2007and have exactly the same
experience as mentioned in the above threads inExcelbut even worse - my
worksheet calculates a graph from a simple 4 columns by 1200 rows section
with no formulas only numbers - it was working well in 2003. In2007it takes
UNBEARABLY longer to the point of being useless !!! . I am using 2.2 GHz AMD
64x2 dual core, 2.0 GB Ram Have I wasted my money on the upgrade?


Do you really need to ask?

Is there
anything I can do to improve performance or will Microsoft do something about
it ? What happened to the dual processor feature?


You could beg for the hotfix. That makes it slightly more bearable, or
alternatively if you are in the UK you could try rejecting the product
as not fit for purpose. It is about time somebody took up the cudgels
on this one.

XL2007 was not ready for release and still isn't. It might get better
after SP1 if we are lucky.
Numeric formatting problems with the simple calculation =77.1*850 does
not inspire confidence.

And I have seen a few larger complex graphs where it is quite a bit
more than an order of magnitude slower.

"Mike Barlow" wrote:
Hello


I believe that ANY Office2007program that runsslowerthan Office 2003
on the *same* problem or application is a defacto software downgrade. Some
of these problems may be due to new features that have not been fully
optimized yet, but I regard any new feature that slows down software
execution to be a mistake -- a mistake that should be fixed. Software
slowdown due to larger problem size is natural, but delays due to cosmetic
new-features should not be allowed.


A 10% slowdown to have more rows or columns would be worthwhile, maybe
even 50%. That level of overhead can be absorbed in a hardware upgrade
or by adding extra ram. But what we have here is a 1000% slowdown for
daring to have user defined axis scaling on graphs with modest amounts
of data.

It works OK if all you ever plot is sales figures by quarter. But it
is dead in the water at present for many scientific users with
datasets of a few thousand points which used to work perfectly in
versions 2000 through 2003.

I believe that Office2007will not gain wide public acceptance if it is
perceived to be excessively slow as indicated by some of the previous posts
here.


I wish I had your confidence. It seems most users are as dumb as
Microsoft thinks they are.

Perhaps more effort should be devoted to optimizingExcelfor
math-intensive, high-speed processing of large data arrays.


Some slowdown in the larger more capable model was inevitable, but I
don't believe this particular problem with the graphics is related to
the grid size. It looks more like daft cosmetic display features
trumping functionality.

"Nick Hodge" wrote:


David


RTM charting is a 'little' better, but very much still to be improved (I am
sure in v.next). Quoting the 1000000 rows (You didn't mention 16k columns)
is something I believeExcelusers, for it is they who demanded them, will
rue the day they did. It's a limitation of current machine power (Generally
available) and the tasksExcelis put to that make me very sceptical.


Anything approaching the old limit of 65k, should IMHO, be in a database.


Charting *will* get improved but is disappointing in this version.


A polite way of saying almost useless. It would be difficult to make
charting any worse

Regards,
Martin Brown



  #22   Report Post  
Old November 5th 07, 03:09 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2007
Posts: 2
Default Pls confirm 2007 chart redraw is up to 10 times slower than 20

Hello

You are right. If nobody has done anything about the problem since your post
in March - a good 7 months should allow something - I hope my post has added
some fuel to the fire.
--
Steen


"Martin Brown" wrote:

On Nov 5, 11:14 am, Steen T. wrote:
Hello

I have just upgraded from Office pro 2003 to2007and have exactly the same
experience as mentioned in the above threads inExcelbut even worse - my
worksheet calculates a graph from a simple 4 columns by 1200 rows section
with no formulas only numbers - it was working well in 2003. In2007it takes
UNBEARABLY longer to the point of being useless !!! . I am using 2.2 GHz AMD
64x2 dual core, 2.0 GB Ram Have I wasted my money on the upgrade?


Do you really need to ask?

Is there
anything I can do to improve performance or will Microsoft do something about
it ? What happened to the dual processor feature?


You could beg for the hotfix. That makes it slightly more bearable, or
alternatively if you are in the UK you could try rejecting the product
as not fit for purpose. It is about time somebody took up the cudgels
on this one.

XL2007 was not ready for release and still isn't. It might get better
after SP1 if we are lucky.
Numeric formatting problems with the simple calculation =77.1*850 does
not inspire confidence.

And I have seen a few larger complex graphs where it is quite a bit
more than an order of magnitude slower.

"Mike Barlow" wrote:
Hello


I believe that ANY Office2007program that runsslowerthan Office 2003
on the *same* problem or application is a defacto software downgrade. Some
of these problems may be due to new features that have not been fully
optimized yet, but I regard any new feature that slows down software
execution to be a mistake -- a mistake that should be fixed. Software
slowdown due to larger problem size is natural, but delays due to cosmetic
new-features should not be allowed.


A 10% slowdown to have more rows or columns would be worthwhile, maybe
even 50%. That level of overhead can be absorbed in a hardware upgrade
or by adding extra ram. But what we have here is a 1000% slowdown for
daring to have user defined axis scaling on graphs with modest amounts
of data.

It works OK if all you ever plot is sales figures by quarter. But it
is dead in the water at present for many scientific users with
datasets of a few thousand points which used to work perfectly in
versions 2000 through 2003.

I believe that Office2007will not gain wide public acceptance if it is
perceived to be excessively slow as indicated by some of the previous posts
here.


I wish I had your confidence. It seems most users are as dumb as
Microsoft thinks they are.

Perhaps more effort should be devoted to optimizingExcelfor
math-intensive, high-speed processing of large data arrays.


Some slowdown in the larger more capable model was inevitable, but I
don't believe this particular problem with the graphics is related to
the grid size. It looks more like daft cosmetic display features
trumping functionality.

"Nick Hodge" wrote:


David


RTM charting is a 'little' better, but very much still to be improved (I am
sure in v.next). Quoting the 1000000 rows (You didn't mention 16k columns)
is something I believeExcelusers, for it is they who demanded them, will
rue the day they did. It's a limitation of current machine power (Generally
available) and the tasksExcelis put to that make me very sceptical.


Anything approaching the old limit of 65k, should IMHO, be in a database.


Charting *will* get improved but is disappointing in this version.


A polite way of saying almost useless. It would be difficult to make
charting any worse

Regards,
Martin Brown



  #23   Report Post  
Old February 28th 08, 06:32 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2008
Posts: 1
Default Pls confirm 2007 chart redraw is up to 10 times slower than 20

Hello,

We are an R&D facility and we use excel almost all the time to plot scatter
charts (x,y) with 10000+ datapoints and we have the sluggish unberable
performace. I 'begged' for the fix and installed SP1 afterwards and I still
have the same slow performance. Actually I dont notice any difference.

Has there been any improvement in this matter ??

Thanks

Juan



"Steen T." wrote:

Hello

You are right. If nobody has done anything about the problem since your post
in March - a good 7 months should allow something - I hope my post has added
some fuel to the fire.
--
Steen


"Martin Brown" wrote:

On Nov 5, 11:14 am, Steen T. wrote:
Hello

I have just upgraded from Office pro 2003 to2007and have exactly the same
experience as mentioned in the above threads inExcelbut even worse - my
worksheet calculates a graph from a simple 4 columns by 1200 rows section
with no formulas only numbers - it was working well in 2003. In2007it takes
UNBEARABLY longer to the point of being useless !!! . I am using 2.2 GHz AMD
64x2 dual core, 2.0 GB Ram Have I wasted my money on the upgrade?


Do you really need to ask?

Is there
anything I can do to improve performance or will Microsoft do something about
it ? What happened to the dual processor feature?


You could beg for the hotfix. That makes it slightly more bearable, or
alternatively if you are in the UK you could try rejecting the product
as not fit for purpose. It is about time somebody took up the cudgels
on this one.

XL2007 was not ready for release and still isn't. It might get better
after SP1 if we are lucky.
Numeric formatting problems with the simple calculation =77.1*850 does
not inspire confidence.

And I have seen a few larger complex graphs where it is quite a bit
more than an order of magnitude slower.

"Mike Barlow" wrote:
Hello

I believe that ANY Office2007program that runsslowerthan Office 2003
on the *same* problem or application is a defacto software downgrade. Some
of these problems may be due to new features that have not been fully
optimized yet, but I regard any new feature that slows down software
execution to be a mistake -- a mistake that should be fixed. Software
slowdown due to larger problem size is natural, but delays due to cosmetic
new-features should not be allowed.


A 10% slowdown to have more rows or columns would be worthwhile, maybe
even 50%. That level of overhead can be absorbed in a hardware upgrade
or by adding extra ram. But what we have here is a 1000% slowdown for
daring to have user defined axis scaling on graphs with modest amounts
of data.

It works OK if all you ever plot is sales figures by quarter. But it
is dead in the water at present for many scientific users with
datasets of a few thousand points which used to work perfectly in
versions 2000 through 2003.

I believe that Office2007will not gain wide public acceptance if it is
perceived to be excessively slow as indicated by some of the previous posts
here.


I wish I had your confidence. It seems most users are as dumb as
Microsoft thinks they are.

Perhaps more effort should be devoted to optimizingExcelfor
math-intensive, high-speed processing of large data arrays.


Some slowdown in the larger more capable model was inevitable, but I
don't believe this particular problem with the graphics is related to
the grid size. It looks more like daft cosmetic display features
trumping functionality.

"Nick Hodge" wrote:

David

RTM charting is a 'little' better, but very much still to be improved (I am
sure in v.next). Quoting the 1000000 rows (You didn't mention 16k columns)
is something I believeExcelusers, for it is they who demanded them, will
rue the day they did. It's a limitation of current machine power (Generally
available) and the tasksExcelis put to that make me very sceptical.

Anything approaching the old limit of 65k, should IMHO, be in a database.

Charting *will* get improved but is disappointing in this version.


A polite way of saying almost useless. It would be difficult to make
charting any worse

Regards,
Martin Brown



  #24   Report Post  
Old February 28th 08, 11:11 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default Pls confirm 2007 chart redraw is up to 10 times slower than 20

You may have to upgrade to Excel 2003. The Excel 2007 SP1 fixed a limited
number of performance issues, and only by a limited amount.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Juan M. Russo" <Juan M. wrote in message
...
Hello,

We are an R&D facility and we use excel almost all the time to plot
scatter
charts (x,y) with 10000+ datapoints and we have the sluggish unberable
performace. I 'begged' for the fix and installed SP1 afterwards and I
still
have the same slow performance. Actually I dont notice any difference.

Has there been any improvement in this matter ??

Thanks

Juan



"Steen T." wrote:

Hello

You are right. If nobody has done anything about the problem since your
post
in March - a good 7 months should allow something - I hope my post has
added
some fuel to the fire.
--
Steen


"Martin Brown" wrote:

On Nov 5, 11:14 am, Steen T. wrote:
Hello

I have just upgraded from Office pro 2003 to2007and have exactly the
same
experience as mentioned in the above threads inExcelbut even worse -
my
worksheet calculates a graph from a simple 4 columns by 1200 rows
section
with no formulas only numbers - it was working well in 2003. In2007it
takes
UNBEARABLY longer to the point of being useless !!! . I am using 2.2
GHz AMD
64x2 dual core, 2.0 GB Ram Have I wasted my money on the upgrade?

Do you really need to ask?

Is there
anything I can do to improve performance or will Microsoft do
something about
it ? What happened to the dual processor feature?

You could beg for the hotfix. That makes it slightly more bearable, or
alternatively if you are in the UK you could try rejecting the product
as not fit for purpose. It is about time somebody took up the cudgels
on this one.

XL2007 was not ready for release and still isn't. It might get better
after SP1 if we are lucky.
Numeric formatting problems with the simple calculation =77.1*850 does
not inspire confidence.

And I have seen a few larger complex graphs where it is quite a bit
more than an order of magnitude slower.

"Mike Barlow" wrote:
Hello

I believe that ANY Office2007program that runsslowerthan Office
2003
on the *same* problem or application is a defacto software
downgrade. Some
of these problems may be due to new features that have not been
fully
optimized yet, but I regard any new feature that slows down
software
execution to be a mistake -- a mistake that should be fixed.
Software
slowdown due to larger problem size is natural, but delays due to
cosmetic
new-features should not be allowed.

A 10% slowdown to have more rows or columns would be worthwhile, maybe
even 50%. That level of overhead can be absorbed in a hardware upgrade
or by adding extra ram. But what we have here is a 1000% slowdown for
daring to have user defined axis scaling on graphs with modest amounts
of data.

It works OK if all you ever plot is sales figures by quarter. But it
is dead in the water at present for many scientific users with
datasets of a few thousand points which used to work perfectly in
versions 2000 through 2003.

I believe that Office2007will not gain wide public acceptance
if it is
perceived to be excessively slow as indicated by some of the
previous posts
here.

I wish I had your confidence. It seems most users are as dumb as
Microsoft thinks they are.

Perhaps more effort should be devoted to optimizingExcelfor
math-intensive, high-speed processing of large data arrays.

Some slowdown in the larger more capable model was inevitable, but I
don't believe this particular problem with the graphics is related to
the grid size. It looks more like daft cosmetic display features
trumping functionality.

"Nick Hodge" wrote:

David

RTM charting is a 'little' better, but very much still to be
improved (I am
sure in v.next). Quoting the 1000000 rows (You didn't mention 16k
columns)
is something I believeExcelusers, for it is they who demanded
them, will
rue the day they did. It's a limitation of current machine power
(Generally
available) and the tasksExcelis put to that make me very
sceptical.

Anything approaching the old limit of 65k, should IMHO, be in a
database.

Charting *will* get improved but is disappointing in this
version.

A polite way of saying almost useless. It would be difficult to make
charting any worse

Regards,
Martin Brown





  #25   Report Post  
Old June 25th 08, 10:29 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 1
Default Pls confirm 2007 chart redraw is up to 10 times slower than 20

I experienced the same issue on my new laptop which has US Vista and
Excel2007. My old one operates on Dutch Vista and Dutch Excel 2007, and is
much faster than both 2003 and 2007 in US version. Clearly there is a bug in
the US version that has been fixed in the Dutch version. I will now install
Dutch 2007 on my new laptop.

Paul Buijs

"Jon Peltier" wrote:

You may have to upgrade to Excel 2003. The Excel 2007 SP1 fixed a limited
number of performance issues, and only by a limited amount.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Juan M. Russo" <Juan M. wrote in message
...
Hello,

We are an R&D facility and we use excel almost all the time to plot
scatter
charts (x,y) with 10000+ datapoints and we have the sluggish unberable
performace. I 'begged' for the fix and installed SP1 afterwards and I
still
have the same slow performance. Actually I dont notice any difference.

Has there been any improvement in this matter ??

Thanks

Juan



"Steen T." wrote:

Hello

You are right. If nobody has done anything about the problem since your
post
in March - a good 7 months should allow something - I hope my post has
added
some fuel to the fire.
--
Steen


"Martin Brown" wrote:

On Nov 5, 11:14 am, Steen T. wrote:
Hello

I have just upgraded from Office pro 2003 to2007and have exactly the
same
experience as mentioned in the above threads inExcelbut even worse -
my
worksheet calculates a graph from a simple 4 columns by 1200 rows
section
with no formulas only numbers - it was working well in 2003. In2007it
takes
UNBEARABLY longer to the point of being useless !!! . I am using 2.2
GHz AMD
64x2 dual core, 2.0 GB Ram Have I wasted my money on the upgrade?

Do you really need to ask?

Is there
anything I can do to improve performance or will Microsoft do
something about
it ? What happened to the dual processor feature?

You could beg for the hotfix. That makes it slightly more bearable, or
alternatively if you are in the UK you could try rejecting the product
as not fit for purpose. It is about time somebody took up the cudgels
on this one.

XL2007 was not ready for release and still isn't. It might get better
after SP1 if we are lucky.
Numeric formatting problems with the simple calculation =77.1*850 does
not inspire confidence.

And I have seen a few larger complex graphs where it is quite a bit
more than an order of magnitude slower.

"Mike Barlow" wrote:
Hello

I believe that ANY Office2007program that runsslowerthan Office
2003
on the *same* problem or application is a defacto software
downgrade. Some
of these problems may be due to new features that have not been
fully
optimized yet, but I regard any new feature that slows down
software
execution to be a mistake -- a mistake that should be fixed.
Software
slowdown due to larger problem size is natural, but delays due to
cosmetic
new-features should not be allowed.

A 10% slowdown to have more rows or columns would be worthwhile, maybe
even 50%. That level of overhead can be absorbed in a hardware upgrade
or by adding extra ram. But what we have here is a 1000% slowdown for
daring to have user defined axis scaling on graphs with modest amounts
of data.

It works OK if all you ever plot is sales figures by quarter. But it
is dead in the water at present for many scientific users with
datasets of a few thousand points which used to work perfectly in
versions 2000 through 2003.

I believe that Office2007will not gain wide public acceptance
if it is
perceived to be excessively slow as indicated by some of the
previous posts
here.

I wish I had your confidence. It seems most users are as dumb as
Microsoft thinks they are.

Perhaps more effort should be devoted to optimizingExcelfor
math-intensive, high-speed processing of large data arrays.

Some slowdown in the larger more capable model was inevitable, but I
don't believe this particular problem with the graphics is related to
the grid size. It looks more like daft cosmetic display features
trumping functionality.

"Nick Hodge" wrote:

David

RTM charting is a 'little' better, but very much still to be
improved (I am
sure in v.next). Quoting the 1000000 rows (You didn't mention 16k
columns)
is something I believeExcelusers, for it is they who demanded
them, will
rue the day they did. It's a limitation of current machine power
(Generally
available) and the tasksExcelis put to that make me very
sceptical.

Anything approaching the old limit of 65k, should IMHO, be in a
database.

Charting *will* get improved but is disappointing in this
version.

A polite way of saying almost useless. It would be difficult to make
charting any worse

Regards,
Martin Brown








  #26   Report Post  
Old June 25th 08, 08:09 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,123
Default Pls confirm 2007 chart redraw is up to 10 times slower than 20

Hi Paul

Do you have a test file?
If you have one send it to me private so I can test it in Dutch/English on my machines

Heb je een bestand dat ik kan gebruiken om te testen
Deze pagina heb ik gemaakt over een ander probleem
http://www.rondebruin.nl/shape.htm

Groeten Ron



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Paul Buijs" <Paul wrote in message ...
I experienced the same issue on my new laptop which has US Vista and
Excel2007. My old one operates on Dutch Vista and Dutch Excel 2007, and is
much faster than both 2003 and 2007 in US version. Clearly there is a bug in
the US version that has been fixed in the Dutch version. I will now install
Dutch 2007 on my new laptop.

Paul Buijs

"Jon Peltier" wrote:

You may have to upgrade to Excel 2003. The Excel 2007 SP1 fixed a limited
number of performance issues, and only by a limited amount.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______


"Juan M. Russo" <Juan M. wrote in message
...
Hello,

We are an R&D facility and we use excel almost all the time to plot
scatter
charts (x,y) with 10000+ datapoints and we have the sluggish unberable
performace. I 'begged' for the fix and installed SP1 afterwards and I
still
have the same slow performance. Actually I dont notice any difference.

Has there been any improvement in this matter ??

Thanks

Juan



"Steen T." wrote:

Hello

You are right. If nobody has done anything about the problem since your
post
in March - a good 7 months should allow something - I hope my post has
added
some fuel to the fire.
--
Steen


"Martin Brown" wrote:

On Nov 5, 11:14 am, Steen T. wrote:
Hello

I have just upgraded from Office pro 2003 to2007and have exactly the
same
experience as mentioned in the above threads inExcelbut even worse -
my
worksheet calculates a graph from a simple 4 columns by 1200 rows
section
with no formulas only numbers - it was working well in 2003. In2007it
takes
UNBEARABLY longer to the point of being useless !!! . I am using 2.2
GHz AMD
64x2 dual core, 2.0 GB Ram Have I wasted my money on the upgrade?

Do you really need to ask?

Is there
anything I can do to improve performance or will Microsoft do
something about
it ? What happened to the dual processor feature?

You could beg for the hotfix. That makes it slightly more bearable, or
alternatively if you are in the UK you could try rejecting the product
as not fit for purpose. It is about time somebody took up the cudgels
on this one.

XL2007 was not ready for release and still isn't. It might get better
after SP1 if we are lucky.
Numeric formatting problems with the simple calculation =77.1*850 does
not inspire confidence.

And I have seen a few larger complex graphs where it is quite a bit
more than an order of magnitude slower.

"Mike Barlow" wrote:
Hello

I believe that ANY Office2007program that runsslowerthan Office
2003
on the *same* problem or application is a defacto software
downgrade. Some
of these problems may be due to new features that have not been
fully
optimized yet, but I regard any new feature that slows down
software
execution to be a mistake -- a mistake that should be fixed.
Software
slowdown due to larger problem size is natural, but delays due to
cosmetic
new-features should not be allowed.

A 10% slowdown to have more rows or columns would be worthwhile, maybe
even 50%. That level of overhead can be absorbed in a hardware upgrade
or by adding extra ram. But what we have here is a 1000% slowdown for
daring to have user defined axis scaling on graphs with modest amounts
of data.

It works OK if all you ever plot is sales figures by quarter. But it
is dead in the water at present for many scientific users with
datasets of a few thousand points which used to work perfectly in
versions 2000 through 2003.

I believe that Office2007will not gain wide public acceptance
if it is
perceived to be excessively slow as indicated by some of the
previous posts
here.

I wish I had your confidence. It seems most users are as dumb as
Microsoft thinks they are.

Perhaps more effort should be devoted to optimizingExcelfor
math-intensive, high-speed processing of large data arrays.

Some slowdown in the larger more capable model was inevitable, but I
don't believe this particular problem with the graphics is related to
the grid size. It looks more like daft cosmetic display features
trumping functionality.

"Nick Hodge" wrote:

David

RTM charting is a 'little' better, but very much still to be
improved (I am
sure in v.next). Quoting the 1000000 rows (You didn't mention 16k
columns)
is something I believeExcelusers, for it is they who demanded
them, will
rue the day they did. It's a limitation of current machine power
(Generally
available) and the tasksExcelis put to that make me very
sceptical.

Anything approaching the old limit of 65k, should IMHO, be in a
database.

Charting *will* get improved but is disappointing in this
version.

A polite way of saying almost useless. It would be difficult to make
charting any worse

Regards,
Martin Brown






  #27   Report Post  
Old June 25th 08, 09:01 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default Pls confirm 2007 chart redraw is up to 10 times slower than 20

Looks like my spelling when I type too fast!

- Jon

"Ron de Bruin" wrote in message
...
Hi Paul

Do you have a test file?
If you have one send it to me private so I can test it in Dutch/English on
my machines

Heb je een bestand dat ik kan gebruiken om te testen
Deze pagina heb ik gemaakt over een ander probleem
http://www.rondebruin.nl/shape.htm

Groeten Ron



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Paul Buijs" <Paul wrote in message
...
I experienced the same issue on my new laptop which has US Vista and
Excel2007. My old one operates on Dutch Vista and Dutch Excel 2007, and is
much faster than both 2003 and 2007 in US version. Clearly there is a bug
in the US version that has been fixed in the Dutch version. I will now
install Dutch 2007 on my new laptop.

Paul Buijs

"Jon Peltier" wrote:

You may have to upgrade to Excel 2003. The Excel 2007 SP1 fixed a
limited number of performance issues, and only by a limited amount.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______


"Juan M. Russo" <Juan M. wrote in
message ...
Hello,

We are an R&D facility and we use excel almost all the time to plot
scatter
charts (x,y) with 10000+ datapoints and we have the sluggish unberable
performace. I 'begged' for the fix and installed SP1 afterwards and I
still
have the same slow performance. Actually I dont notice any
difference.

Has there been any improvement in this matter ??

Thanks

Juan



"Steen T." wrote:

Hello

You are right. If nobody has done anything about the problem since
your post
in March - a good 7 months should allow something - I hope my post
has added
some fuel to the fire.
--
Steen


"Martin Brown" wrote:

On Nov 5, 11:14 am, Steen T.
wrote:
Hello

I have just upgraded from Office pro 2003 to2007and have exactly
the same
experience as mentioned in the above threads inExcelbut even
worse - my
worksheet calculates a graph from a simple 4 columns by 1200 rows
section
with no formulas only numbers - it was working well in 2003.
In2007it takes
UNBEARABLY longer to the point of being useless !!! . I am using
2.2 GHz AMD
64x2 dual core, 2.0 GB Ram Have I wasted my money on the
upgrade?

Do you really need to ask?

Is there
anything I can do to improve performance or will Microsoft do
something about
it ? What happened to the dual processor feature?

You could beg for the hotfix. That makes it slightly more bearable,
or
alternatively if you are in the UK you could try rejecting the
product
as not fit for purpose. It is about time somebody took up the
cudgels
on this one.

XL2007 was not ready for release and still isn't. It might get
better
after SP1 if we are lucky.
Numeric formatting problems with the simple calculation =77.1*850
does
not inspire confidence.

And I have seen a few larger complex graphs where it is quite a bit
more than an order of magnitude slower.

"Mike Barlow" wrote:
Hello

I believe that ANY Office2007program that runsslowerthan
Office 2003
on the *same* problem or application is a defacto software
downgrade. Some
of these problems may be due to new features that have not been
fully
optimized yet, but I regard any new feature that slows down
software
execution to be a mistake -- a mistake that should be fixed.
Software
slowdown due to larger problem size is natural, but delays due
to cosmetic
new-features should not be allowed.

A 10% slowdown to have more rows or columns would be worthwhile,
maybe
even 50%. That level of overhead can be absorbed in a hardware
upgrade
or by adding extra ram. But what we have here is a 1000% slowdown
for
daring to have user defined axis scaling on graphs with modest
amounts
of data.

It works OK if all you ever plot is sales figures by quarter. But
it
is dead in the water at present for many scientific users with
datasets of a few thousand points which used to work perfectly in
versions 2000 through 2003.

I believe that Office2007will not gain wide public
acceptance if it is
perceived to be excessively slow as indicated by some of the
previous posts
here.

I wish I had your confidence. It seems most users are as dumb as
Microsoft thinks they are.

Perhaps more effort should be devoted to optimizingExcelfor
math-intensive, high-speed processing of large data arrays.

Some slowdown in the larger more capable model was inevitable, but
I
don't believe this particular problem with the graphics is related
to
the grid size. It looks more like daft cosmetic display features
trumping functionality.

"Nick Hodge" wrote:

David

RTM charting is a 'little' better, but very much still to be
improved (I am
sure in v.next). Quoting the 1000000 rows (You didn't mention
16k columns)
is something I believeExcelusers, for it is they who demanded
them, will
rue the day they did. It's a limitation of current machine
power (Generally
available) and the tasksExcelis put to that make me very
sceptical.

Anything approaching the old limit of 65k, should IMHO, be in
a database.

Charting *will* get improved but is disappointing in this
version.

A polite way of saying almost useless. It would be difficult to
make
charting any worse

Regards,
Martin Brown






  #28   Report Post  
Old September 6th 08, 10:15 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2008
Posts: 1
Default Pls confirm 2007 chart redraw is up to 10 times slower than 2003

Nice to see that the Problem that I am currently seeing in Office 2007
enterprise dates back to the beta. I have 10 curves for one chart each easly
could have upto 2000 points, redraw will eat up 100% of one core for a good
half minute before an update, and mean while excel is useless. (2.00Ghz,
Intel P7350, 4.00 GB of RAM, with vista x64)

"larry godfrey" wrote:

I have complex charts, with many data points. The redraw time on my machine
in Excel 2003 (all updates for office and wxp installed) is 2-3 sec, which I
consider extremely slow, so I was looking forward to an new chart engine with
better speed from 2007, but am flabergasted at how slow 2007 is.
Try this...create a line chart, 12 columns of 5000 points each. Put it
imbeded in a worksheet. Tab to another worksheet, tab back, time the redraw.
On my machine (3 ghz, 2gig ram), redraw time is 2-3 sec for all the lines to
show up on the graph. In 2007, it takes a full minute! the graph looks
better (lines are more clear), but wow, this redraw time is crazy! I created
the graph in 2003, pulled it into 2007 and saved it as 2007.xlsm file type.

I also have a graph with ~ 50 5k point lines, of which I hide most of them
at any one time. This chart redraw in 2007 can go on for 5 minutes!
(compared to 10-15 sec in 2003)

Am I unaware of some setting to speed things up, or did MS realy make charts
10X slower to redraw?
Best regards
Larry



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 do I make a chart with several times during a day [email protected] Excel Discussion (Misc queries) 6 December 23rd 05 03:13 PM
Creating a chart from two tables of Times Stevie_J Excel Discussion (Misc queries) 1 July 23rd 05 08:56 PM
How to chart start and stop times tresscott Charts and Charting in Excel 1 April 10th 05 11:04 PM
Timeline Chart? ckrogers Charts and Charting in Excel 3 March 17th 05 10:20 PM
If I have data for varying times in a column chart, how do I space tc1967uk Charts and Charting in Excel 1 February 22nd 05 07:03 PM


All times are GMT +1. The time now is 10:43 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017