excel runs very slow with large matrices

D

diaemus

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi everyone! Since I migrated to Macs over a year ago, I'm having trouble with Excel 2008. When I need to work with a large matrix, for instance 500x300, Excel runs very slowly. And it is not slow only for making calculations, it is especially slow for simply scrolling up and down or to the side. It's almost unbelievable. In Excel 2007 for Windows running under VMWare Fusion 2.0 in the same iMac, speed is much faster with the same matrix. Can someone please help me? Is there a way to make Excel:Mac 2008 run faster?
 
J

John McGhie

No, there's no way to make it run any faster. Excel 2008 is a slug, and
there's not a lot you can do about it.

Make sure you have all the latest updates applied: there were some important
fixes that will make it quicker. But if you have applied the updates,
that's as good as it gets.

The next version, due at the end of the year, should be several orders of
magnitude faster.

Cheers


Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
Hi everyone! Since I migrated to Macs over a year ago, I'm having trouble with
Excel 2008. When I need to work with a large matrix, for instance 500x300,
Excel runs very slowly. And it is not slow only for making calculations, it is
especially slow for simply scrolling up and down or to the side. It's almost
unbelievable. In Excel 2007 for Windows running under VMWare Fusion 2.0 in
the same iMac, speed is much faster with the same matrix. Can someone please
help me? Is there a way to make Excel:Mac 2008 run faster?

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]
 
D

diaemus

Dear John, thanks for the reply. Excel is up to date here, so I'll have to wait for the next version... It's a shame how the same program can be so different on each platform. I was very disappointed, because 50% of the time I work in Excel organizing large matrices.
 
J

John McGhie

Yeah, well, that's the key to it. It's NOT "the same program".

Excel 2008 for the Mac is a "functionally equivalent" Macintosh OS X program
written to provide the most-commonly required Excel functions on the Mac.

But it's not "the same program". Not even close :)

The big push in Excel 2008 was to get the new file formats and Intel
processors working "at all" on the Mac. They built on that work for Office
2011.

If we think back to when this all happened (2006, 2007 when they were making
Excel 2008) Microsoft got flat-footed three times in quick succession...
Apple came out with a new OS and a new processor at the same time as Excel
PC came out with a new file format. Microsoft's Mac Business Unit simply
ran out of time, people, and money, to do all of that in the time available.

Software Development Engineers capable of producing to the standard required
by major OEM software vendors such as Microsoft and Apple do not grow on
trees. You have to recruit from the best and brightest, and spend five
years training them. When Apple announced a new OS and a new processor, all
of a sudden there were not enough good coders in town to do the work.

This time, they've had time to find/develop ten times as many coders, and
four times as long to do the work. I think the PC users are going to be
jealous of us this time around :)

Cheers

Dear John, thanks for the reply. Excel is up to date here, so I'll have to
wait for the next version... It's a shame how the same program can be so
different on each platform. I was very disappointed, because 50% of the time I
work in Excel organizing large matrices.

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]
 
D

diaemus

Dear John, thanks for the explanation. It's good to hear the story from an insider. Ok, I'll wait for the new version! Until then the solution for me is to work on Excel:Windows via Fusion or on Numbers (which frankly is not as good as Excel for serious business).
 

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

Top