EXCEL 2007 VERY SLOW WITH LARGE DATA CHARTS

I've also been very frustrated with the very slow charting of 2007 with
vista. I've had to spend a lot of time modifying my macros to eliminate
"select" because it drives a lot of cpu. One trick I've found that works is
to put the graphs in a row and then "hide" the row while I generate the
graphs with the macros. Once the graphs are created/modified with the macros
I then "unhide" the row/graph. It speeds up the time greatly
--
halfpint


"Norm" wrote:

> I have spreadsheets going easily from 16000 to 64000 lines, I used to make
> EXCEL 2003 charts by using 3-4 worksheets easily. They were big but ran very
> fast. EXCEL 2007 is simply very slow, even if I try to do a chart from
> scratch.
>
> Simple line charts, scatter points nothing graphically demanding and my
> computer is a P4 full of memory.
>
> Anybody out there with the same problem?
>
> Norm

Disable screen updating, and remove the selection from your code. I can
imagine setting the chart height to zero while working on it will have
unexpected consequences.

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


"halfpint" <halfpint DeleteThis @discussions.microsoft.com> wrote in message
news:577AAE9F-61EA-42F7-AFDE-1E7CDC681738@microsoft.com...
> I've also been very frustrated with the very slow charting of 2007 with
> vista. I've had to spend a lot of time modifying my macros to eliminate
> "select" because it drives a lot of cpu. One trick I've found that works
> is
> to put the graphs in a row and then "hide" the row while I generate the
> graphs with the macros. Once the graphs are created/modified with the
> macros
> I then "unhide" the row/graph. It speeds up the time greatly
> --
> halfpint
>
>
> "Norm" wrote:
>
>> I have spreadsheets going easily from 16000 to 64000 lines, I used to
>> make
>> EXCEL 2003 charts by using 3-4 worksheets easily. They were big but ran
>> very
>> fast. EXCEL 2007 is simply very slow, even if I try to do a chart from
>> scratch.
>>
>> Simple line charts, scatter points nothing graphically demanding and my
>> computer is a P4 full of memory.
>>
>> Anybody out there with the same problem?
>>
>> Norm

I failed to mention that I had previously turned off screen updating which
helped as the macro moved from various pages but it continues to redraw the
graph as the macro executes on that page. I need to "select the plots" to
have the macros calculate the min and max I need. For lack of any thing else
to try I used the hide feature. I have one PC with XP with both Excel 2000
and 2007 and ran run side by side comparisons with Excel 2000 which runs the
plots in less than a second whereas with 2007 it takes 15 seconds per plot.

Another problem I've seen is the following: I have another PC with Vista
which also has both 2000 and 2007 Excel. If I try to load the Excel 2000
file (which works fine on the XP version) on a Vista machine it errors
out...don't know why. Both PC's have plenty capacity and speed with duo
processors. thanks in advance for any help.
--
halfpint


"Jon Peltier" wrote:

> Disable screen updating, and remove the selection from your code. I can
> imagine setting the chart height to zero while working on it will have
> unexpected consequences.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>
>
> "halfpint" <halfpint.RemoveThis@discussions.microsoft.com> wrote in message
> news:577AAE9F-61EA-42F7-AFDE-1E7CDC681738@microsoft.com...
> > I've also been very frustrated with the very slow charting of 2007 with
> > vista. I've had to spend a lot of time modifying my macros to eliminate
> > "select" because it drives a lot of cpu. One trick I've found that works
> > is
> > to put the graphs in a row and then "hide" the row while I generate the
> > graphs with the macros. Once the graphs are created/modified with the
> > macros
> > I then "unhide" the row/graph. It speeds up the time greatly
> > --
> > halfpint
> >
> >
> > "Norm" wrote:
> >
> >> I have spreadsheets going easily from 16000 to 64000 lines, I used to
> >> make
> >> EXCEL 2003 charts by using 3-4 worksheets easily. They were big but ran
> >> very
> >> fast. EXCEL 2007 is simply very slow, even if I try to do a chart from
> >> scratch.
> >>
> >> Simple line charts, scatter points nothing graphically demanding and my
> >> computer is a P4 full of memory.
> >>
> >> Anybody out there with the same problem?
> >>
> >> Norm
>
>
>

> I need to "select the plots" to have the macros calculate the min and max
> I need.

In general, you do not need to select anything. This gets an axis minimum
from an unselected chart on a not necessarily active sheet in a not
necessarily active workbook:

Workbooks("Book1.xls).Worksheets("Sheet1").ChartObjects(1).Chart.Axes(xlValue,
xlPrimary).MinimumScale

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


"halfpint" <halfpint DeleteThis @discussions.microsoft.com> wrote in message
news:272C2E1C-E0C3-4515-8AA6-27E799D678E7@microsoft.com...
>I failed to mention that I had previously turned off screen updating which
> helped as the macro moved from various pages but it continues to redraw
> the
> graph as the macro executes on that page. I need to "select the plots" to
> have the macros calculate the min and max I need. For lack of any thing
> else
> to try I used the hide feature. I have one PC with XP with both Excel
> 2000
> and 2007 and ran run side by side comparisons with Excel 2000 which runs
> the
> plots in less than a second whereas with 2007 it takes 15 seconds per
> plot.
>
> Another problem I've seen is the following: I have another PC with Vista
> which also has both 2000 and 2007 Excel. If I try to load the Excel 2000
> file (which works fine on the XP version) on a Vista machine it errors
> out...don't know why. Both PC's have plenty capacity and speed with duo
> processors. thanks in advance for any help.
> --
> halfpint
>
>
> "Jon Peltier" wrote:
>
>> Disable screen updating, and remove the selection from your code. I can
>> imagine setting the chart height to zero while working on it will have
>> unexpected consequences.
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Tutorials and Custom Solutions
>> Peltier Technical Services, Inc. - http://PeltierTech.com
>> _______
>>
>>
>> "halfpint" <halfpint DeleteThis @discussions.microsoft.com> wrote in message
>> news:577AAE9F-61EA-42F7-AFDE-1E7CDC681738@microsoft.com...
>> > I've also been very frustrated with the very slow charting of 2007 with
>> > vista. I've had to spend a lot of time modifying my macros to
>> > eliminate
>> > "select" because it drives a lot of cpu. One trick I've found that
>> > works
>> > is
>> > to put the graphs in a row and then "hide" the row while I generate the
>> > graphs with the macros. Once the graphs are created/modified with the
>> > macros
>> > I then "unhide" the row/graph. It speeds up the time greatly
>> > --
>> > halfpint
>> >
>> >
>> > "Norm" wrote:
>> >
>> >> I have spreadsheets going easily from 16000 to 64000 lines, I used to
>> >> make
>> >> EXCEL 2003 charts by using 3-4 worksheets easily. They were big but
>> >> ran
>> >> very
>> >> fast. EXCEL 2007 is simply very slow, even if I try to do a chart
>> >> from
>> >> scratch.
>> >>
>> >> Simple line charts, scatter points nothing graphically demanding and
>> >> my
>> >> computer is a P4 full of memory.
>> >>
>> >> Anybody out there with the same problem?
>> >>
>> >> Norm
>>
>>
>>

I found this hotfix description which addressed the problem:
http://support.microsoft.com/kb/938538/en-us
I contacted customer support to get the file and they sent me here:
https://support.microsoft.com/contactus2/emailcontact.aspx?scid=sw;en;...0&WS=ho
Used 938538 for the KB Article Number and X86 for the platform. I'm
awaiting a response...

-Albert

On Nov 8, 9:07 am, "Jon Peltier" <jonxlmv... RemoveThis @SPAMpeltiertech.com>
wrote:
> > I need to "select the plots" to have the macros calculate the min and max
> > I need.
>
> In general, you do not need to select anything. This gets an axis minimum
> from an unselected chart on a not necessarily active sheet in a not
> necessarily active workbook:
>
> Workbooks("Book1.xls).Worksheets("Sheet1").ChartObjects(1).Chart.Axes(xlValue,
> xlPrimary).MinimumScale
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. -http://PeltierTech.com
> _______
>
> "halfpint" <halfp... RemoveThis @discussions.microsoft.com> wrote in message
>
> news:272C2E1C-E0C3-4515-8AA6-27E799D678E7@microsoft.com...
>
> >I failed to mention that I had previously turned off screen updating which
> > helped as the macro moved from various pages but it continues to redraw
> > the
> > graph as the macro executes on that page. I need to "select the plots" to
> > have the macros calculate the min and max I need. For lack of any thing
> > else
> > to try I used the hide feature. I have one PC with XP with both Excel
> > 2000
> > and 2007 and ran run side by side comparisons with Excel 2000 which runs
> > the
> > plots in less than a second whereas with 2007 it takes 15 seconds per
> > plot.
>
> > Another problem I've seen is the following: I have another PC with Vista
> > which also has both 2000 and 2007 Excel. If I try to load the Excel 2000
> > file (which works fine on the XP version) on a Vista machine it errors
> > out...don't know why. Both PC's have plenty capacity and speed with duo
> > processors. thanks in advance for any help.
> > --
> > halfpint
>
> > "Jon Peltier" wrote:
>
> >> Disable screen updating, and remove the selection from your code. I can
> >> imagine setting the chart height to zero while working on it will have
> >> unexpected consequences.
>
> >> - Jon
> >> -------
> >> Jon Peltier, Microsoft Excel MVP
> >> Tutorials and Custom Solutions
> >> Peltier Technical Services, Inc. -http://PeltierTech.com
> >> _______
>
> >> "halfpint" <halfp... RemoveThis @discussions.microsoft.com> wrote in message
> >>news:577AAE9F-61EA-42F7-AFDE-1E7CDC681738@microsoft.com...
> >> > I've also been very frustrated with the very slow charting of 2007 with
> >> > vista. I've had to spend a lot of time modifying my macros to
> >> > eliminate
> >> > "select" because it drives a lot of cpu. One trick I've found that
> >> > works
> >> > is
> >> > to put the graphs in a row and then "hide" the row while I generate the
> >> > graphs with the macros. Once the graphs are created/modified with the
> >> > macros
> >> > I then "unhide" the row/graph. It speeds up the time greatly
> >> > --
> >> > halfpint
>
> >> > "Norm" wrote:
>
> >> >> I have spreadsheets going easily from 16000 to 64000 lines, I used to
> >> >> make
> >> >> EXCEL 2003 charts by using 3-4 worksheets easily. They were big but
> >> >> ran
> >> >> very
> >> >> fast. EXCEL 2007 is simply very slow, even if I try to do a chart
> >> >> from
> >> >> scratch.
>
> >> >> Simple line charts, scatter points nothing graphically demanding and
> >> >> my
> >> >> computer is a P4 full of memory.
>
> >> >> Anybody out there with the same problem?
>
> >> >> Norm

On Nov 5, 8:11 pm, halfpint <halfp....DeleteThis@discussions.microsoft.com>
wrote:
> I've also been very frustrated with the very slow charting of 2007 with
> vista. I've had to spend a lot of time modifying my macros to eliminate
> "select" because it drives a lot of cpu. One trick I've found that works is
> to put the graphs in a row and then "hide" the row while I generate the
> graphs with the macros. Once the graphs are created/modified with the macros
> I then "unhide" the row/graph. It speeds up the time greatly
> --
> halfpint"Norm" wrote:
> > I have spreadsheets going easily from 16000 to 64000 lines, I used to make
> > EXCEL 2003 charts by using 3-4 worksheets easily. They were big but ran very
> > fast. EXCEL 2007 is simply very slow, even if I try to do a chart from
> > scratch.
>
> > Simple line charts, scatter points nothing graphically demanding and my
> > computer is a P4 full of memory.
>
> > Anybody out there with the same problem?
>
> > Norm

I have the exact same problem that is so FRUSTRATING!!! I used to
make plots with a string of 30K points from a text file with no
problem in 2003. I have tried 3 machines with XP and VISTA with tons
of ram and cpu speed and it takes 30 secs to plot 10K of data. Any
change with take about 15 to 20 secs which is unacceptable. This is a
major step backward I will use open office. Any other solutions?


Mike O