Google
 
Webnews.only-4-geeks.com
Interesting places
news.only-4-geeks.com Forum Index » Excel

large worksheet runs very slow on Excel for Mac

 
Jump to:  
 
oj
PostPosted: 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
PostPosted: 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
PostPosted: 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
PostPosted: 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
PostPosted: 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
PostPosted: 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
PostPosted: 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
PostPosted: 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
PostPosted: 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
 

Page 1 of 1 .:.

Google
 
Webnews.only-4-geeks.com

Windows Update | C++ | C | PHP | JavaScript | Photoshop | Programming | Windows 2000 | Python | Windows XP | Object | Flash | Flash - ActionScript | Paint Shop Pro | Excel | PowerPoint | Access | Word | Windows 98 | Internet Explorer 6.0 | CorelDraw12 | Java | XML | asm x86 | Linux Mandrake | Linux RedHat | Outlook |  | news from newsgroups |_ | s

Web Templates

Awesome Website Templates ©

ChoraƂ gregoriaƄski Paris Hilton teledyski DziaƂalnoƛć gospodarcza Transport Portal Miasteczko opolskie