|  | large worksheet runs very slow on Excel for Mac |  | |
| | | oj |  |
| Posted: Thu Jun 26, 2008 2:02 pm Post subject: large worksheet runs very slow on Excel for Mac |  |
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 |  |
| Posted: Thu Jun 26, 2008 2:02 pm Post subject: Re: large worksheet runs very slow on Excel for Mac |  |
On 6/26/08 10:02 AM, in article 4170e9d7-db75-4acc-85ab-5359ad8ae5e6@f36g2000hsa.googlegroups.com, "oj" <OJGanesh@gmail.com> wrote:
| Quote: | 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?
-- Bob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom |
| |
| | | oj |  |
| Posted: Tue Jul 01, 2008 2:51 pm Post subject: Re: large worksheet runs very slow on Excel for Mac |  |
| |  | |
On Jun 26, 10:29 am, Bob Greenblatt <b...@nospam.com> wrote:
| Quote: | On 6/26/08 10:02 AM, in article 4170e9d7-db75-4acc-85ab-5359ad8ae...@f36g2000hsa.googlegroups.com, "oj"
OJGan...@gmail.com> wrote: 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?
-- Bob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom
|
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 |  |
| Posted: Tue Jul 08, 2008 1:46 pm Post subject: RE: large worksheet runs very slow on Excel for Mac |  |
| |  | |
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" wrote:
| Quote: | 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.
|
|
| |
| | | oj |  |
| Posted: Tue Jul 08, 2008 5:52 pm Post subject: Re: large worksheet runs very slow on Excel for Mac |  |
| |  | |
On Jul 1, 10:51 am, oj <OJGan...@gmail.com> wrote:
| Quote: | On Jun 26, 10:29 am, Bob Greenblatt <b...@nospam.com> wrote:
On 6/26/08 10:02 AM, in article 4170e9d7-db75-4acc-85ab-5359ad8ae...@f36g2000hsa.googlegroups.com, "oj"
OJGan...@gmail.com> wrote: 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?
-- Bob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom
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 |  |
| Posted: Fri Jul 11, 2008 12:31 pm Post subject: Re: large worksheet runs very slow on Excel for Mac |  |
| Quote: | 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 |  |
| Posted: Sat Jul 12, 2008 3:51 am Post subject: Re: large worksheet runs very slow on Excel for Mac |  |
| |  | |
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
On 7/11/08 7:31 AM, in article 95A88A61-ABD5-4FD1-AC3A-E21D34F2F7B9@microsoft.com, "Jason" <Jason@discussions.microsoft.com> wrote:
| Quote: | 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. |
|
| |
| | | Jason |  |
| Posted: Sat Jul 12, 2008 1:04 pm Post subject: Re: large worksheet runs very slow on Excel for Mac |  |
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).
| Quote: | 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
|
|
| |
| | | kumar35885 |  |
| Posted: Mon Sep 01, 2008 3:01 pm Post subject: RE: large worksheet runs very slow on Excel for Mac |  |
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 |
| |
|
|