Performance is unusably slow..

[nonresidentalien]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I am running Excel on the latest MacBook Pro but as soon as I handle somewhat larger tables (i.e. over 100 rows), performance of Excel becomes so incredibly slow that the application is virtually unusable to me. Is there any tweak? Are there others experiencing the same issue?

 

[John McGhie]

There are two things you need to do:

1) Apply the most recent updates to both OS X and Excel

2) Ensure the computer has more than four gigs of RAM.

Now, this is a bug caused by the following:
* The Paper size is set to something other than US Letter
* The display is set to something other than Normal View
* The default printer driver is from Hewlett Packard

If any of those three are NOT true, performance will be OK. I suggest that
you set your View to Normal.

Microsoft is working on the bug, there should be a patch out soon.

Cheers

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
I am running Excel on the latest MacBook Pro but as soon as I handle somewhat
larger tables (i.e. over 100 rows), performance of Excel becomes so
incredibly slow that the application is virtually unusable to me. Is there
any tweak? Are there others experiencing the same issue?

--

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
+61 4 1209 1410, mailto:[email protected]

 

[nonresidentalien]

John,

Thank you very much for your fast response. As a matter for fact, I had the settings causing the bug, and I have changed it as far as I could. The situation improved to some extent but I am still experiencing issues with large tables that that live on a server and that are also opened from MS Office 2007 on a regular base.

Best

Lars

 

[John McGhie]

Hi Lars:

Change those big sheets to .xlsb format and they will perform and open
quicker, in both 2007 and 2008.

Excel 2008 is slow and always will be: they did not have time to optimise it
properly before they had to put it on sale, so now it never will be. The
next version will be a lot faster, but that's maybe 12 months away, so in
the meantime, add memory to that Mac.

Cheers

John,

Thank you very much for your fast response. As a matter for fact, I had the
settings causing the bug, and I have changed it as far as I could. The
situation improved to some extent but I am still experiencing issues with
large tables that that live on a server and that are also opened from MS
Office 2007 on a regular base.

Best

Lars

--

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
+61 4 1209 1410, mailto:[email protected]