[phpBB Debug] PHP Notice: in file [ROOT]/includes/session.php on line 2208: Array to string conversion
[phpBB Debug] PHP Notice: in file [ROOT]/includes/session.php on line 2208: Array to string conversion
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4688: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3823)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4690: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3823)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4691: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3823)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4692: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3823)
[phpBB Debug] PHP Notice: in file [ROOT]/includes/session.php on line 2208: Array to string conversion
NeoThermic.com • Post a reply

Slow Excel 2007 with graphs of large data points

Post a reply

Confirmation code
Enter the code exactly as it appears. All letters are case insensitive.

BBCode is OFF
Smilies are OFF
Topic review
   

Expand view Topic review: Slow Excel 2007 with graphs of large data points

Slow Excel 2007 with graphs of large data points

Post by NeoThermic » Thu, 10 2008 Apr 14:40:06

I'm sure anyone using Excel 2007 has run into this show stopping problem. You have a huge dataset, say something like 10k results or more (benchmarking data in my case). You format the data, and then put it into a graph. At this point Excel 2007 becomes slow. Sometimes it'll just crash. Either way it becomes unworkable with large data sets that posed no problem for Excel 2003. In an effort to solve the problem, I ended up having a hackish fix. I'd just do one operation on the graph, save the results, close, open the workbook up and repeat. Obviously this took time.

I was pointed to a fix by kellanved. Apparently Microsoft are aware of this issue and have made a hotfix for it. Since the hotfix hasn't been through the vigorous testing that they do *cough**cough*, you have to request the hotfix from MS.
Excel 2007 hotfix package: June 13, 2007 details the hotfix and when to request for it.

After installing the hotfix (which took MS a nice quick hour and a half to return my request), Excel flies. The large data sets have become manageable, no more hackish fixing to the problem.

So if you've got the same issue, give the hotfix a try.

Top

cron