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
|