large worksheet runs very slow on Excel for Mac

[oj]

Hey we have a very large document (10 worksheets of 1024 rows x 26
columns, with graphs, roughly 11 MB) which opens very slowly on Excel
on the Mac. Using the same document on Excel for Windows doesn't
seem to have any problems. Scrolling around the document, selecting
cells, switching tabs, or just opening it causes Excel on the Mac to
slow down considerably. It's just **very** pokey. Is there
anything we can do about it?

Thanks.

 

[Bob Greenblatt]

Hey we have a very large document (10 worksheets of 1024 rows x 26
columns, with graphs, roughly 11 MB) which opens very slowly on Excel
on the Mac. Using the same document on Excel for Windows doesn't
seem to have any problems. Scrolling around the document, selecting
cells, switching tabs, or just opening it causes Excel on the Mac to
slow down considerably. It's just **very** pokey. Is there
anything we can do about it?

Thanks.

What version of Excel, OS, and how much RAM, and free disk space? Is the
file on a network?

 

[oj]

What version of Excel, OS, and how much RAM, and free disk space? Is the
file on a network?

Excel 2008 (on the Mac), however it did the same thing with Excel 2004
2 GB of RAM
250 GB disk, less than 50% full
using OS X 10.5, however it did the same thing with 10.4

The file is usually on the network, but is still slow when copied to
the local disk (in the computer)
We've recently duplicated this same problem on another (non-PPC) mac...

 

[Martha]

When I switched from 2004 to 2008, one of the first things I noticed was how
much more slowly Excel processed my sorts. This is one of the MANY problems I
have noticed with 2008.

I have been a long-time Microsoft user. When 2004 came out, I noticed
problems in Word with extra spaced inserted before words after a return
(throwing off the alignment). Then in 2008, the same bugs were there.
Microsoft does not walk the talk when they say they are committed to
Macintosh.

 

[oj]

Excel 2008 (on the Mac), however it did the same thing with Excel 2004
2 GB of RAM
250 GB disk, less than 50% full
using OS X 10.5, however it did the same thing with 10.4

The file is usually on the network, but is still slow when copied to
the local disk (in the computer)
We've recently duplicated this same problem on another (non-PPC) mac...

I guess no one else out there is having this problem. We've tried
checking many different things, including different versions of Excel,
and changing the network connection. These spreadsheets just seem to
be *very* slow to work with on the Mac (again, Excel in Windows has no
problems)... Anyone have any idea why this may be?

 

[Jason]

I guess no one else out there is having this problem. We've tried
checking many different things, including different versions of Excel,
and changing the network connection. These spreadsheets just seem to
be *very* slow to work with on the Mac (again, Excel in Windows has no
problems)... Anyone have any idea why this may be?

I'm experiencing the exact same problem using excel 2008 on a PPC running
10.5.4 with 2 GB or memory and a brand new intel mac running 10.5.4 with 4 GB
of memory and tons of free disk space (with the excel file on the local disk
in both cases). This problem is most certainly within excel and not a result
of the computer / operating system / configuration.

 

[Derrick]

Did you apply the latest updates for office 2008? I had same problem with a
32 sheet work book with 1200+ rows and about 60 columns (bill of materials)
that did this till I updated my office now it works fine. Was also accessing
it over lan. Also had problems with it displaying results from a formula
unless I saved. Upon updating office, both were cured. On a macbook pro
10.5.4

 

[Jason]

Can't of course speak for oj, but I'm running Excel version 12.1.1 (080522).
After a little searching I've seen similar complaints regarding Excel 2007
(PC). My suspicion is Excel has been Vista-ed (i.e. there are so many
preloaded features that the basic program becomes unusable slow).

 

[kumar35885]

Same problem here. Anything over 7Mb runs very slowly.

I have a spreadsheet with 200,000 rows and 50 columns ~50Mb and everything
takes 5minutes to complete.

Time to switch to spotfire