View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Martin Brown Martin Brown is offline
external usenet poster
 
Posts: 230
Default Excel 2007 Non-responsive

On Sep 25, 2:56 pm, Sheena wrote:
Background: The issue is on a Vista system running Office 2007. The user is
creating an excel workbook with 5-7 worksheets. The 1st 2 worksheets have
1000 - 6000 records, the rest of the sheets are graphs and charts that are
created from those records. In one of the charts she is creating a dot
diagram which has 1000-6000 dots plotted on it.

Issue: The spreadsheet with the graphs are changing each time the document
is closed and reopened (dots are changing locations) and the workbook is
constantly becoming non-responsive.

Please advise on what could be causing this issue.


Attempting to use XL2007 for charts containing non-trivial amounts of
data. BIG MISTAKE!
(see all the other threads here about large datasets and s-l--o-----w
charts)

There are some supposed hotfixes you have to beg for from M$ support
that slightly improve things.

Install XL2003 instead and you will find that complex charts run at
least an order of magnitude faster.

Regards,
Martin Brown