View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
halfpint halfpint is offline
external usenet poster
 
Posts: 7
Default 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