EXCEL 2007 VERY SLOW WITH LARGE DATA CHARTS

jadbal, I downloaded the hotfix and it appears to have solved the problem. I
only wish I had this fix before I spent all those hours trying to speed up
the macros. Thanks for the help, do you know if MS will provide this fix to
others....it's a serious problem. thanks again, halfpint
--
halfpint


"jadbal" wrote:

> 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... DeleteThis @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... 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" <halfp... 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 have same problem with large data sets. In earlier Excel versions, they
ran just fine, but in Excel 2007, the program chokes up: e.g., I try to do a
'search-and--replace' in one column, and the systems freezes for a minute
(showing "not responding" in the banner); e.g., I try deleting a column at
the very end of the spreadsheet, and the program freezes, then crashes. I'm
running Excel 2007 on both my desktop and laptop (pretty new PC's with tons
of power and storage), and am having identical problems.

Worst of all, I can't find any helpful hints on the internet to deal with
this. As it stands, Excel 2007 is pretty useless for my needs, and I'll have
to get back to an earlier version. So much for the much-touted million-row
expansion ...

"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