Excel Charting speed

M

MarkJames

Is there a central point where I can get the most up to date situation on
charting in Excel 2007? Where?

I have a macro that reads a text format log file from another application
and charts the details in near real time. Even my most cut down simulation of
this runs significantly slower in Excel 2007 than 2003.
ScreenUpdating is off, Calculations are manual. Threading is disabled. The
simulation has only data in the worksheet (no objects) plus the chart.
Excel version 12.0.6300.5000 SP1 MSO 12.0.6213.1000
The live data can be 250 columns, 30000 rows, but my simulation test use
about 600 rows, 20 columns, and Excel 2007 doesn't cope.
The simulation is not accessing any other files.
 
M

mechi

Thanks for helping me decide not to work with Excel 2007 - I'll wait to see
the answer to your post
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Live data capture and charting speed 0
VBA speed up 0
Excel 2007 limitations when plotting variable width column charts 1
Excel-2007 doesn't sort strings as described in documentation 3
Automatic Axis Titles in Excel 2007 4
how to speed up excel workbook 1
Speed and the "number dates". 0
Excel 2007 VBA-XLL macro speed slow 1

Top