Why is Excel so slow?

Discussion in 'Mac Apps and Mac App Store' started by Macaddicttt, Jan 24, 2005.

  1. Macaddicttt macrumors 6502a

    Macaddicttt

    Joined:
    Apr 22, 2004
    Location:
    San Diego, CA
    #1
    Anyone have any trouble with Excel being really slow? I'm really having problems with it. My machine should be more than enough to handle large (about 30MB) Excel files (1.2 GHz iBook G4 with 768 MB RAM). The find feature is especially slow, but I also see real slow downs when copying or pasting. Anyone have any ideas? Thanks.
     
  2. clayj macrumors 604

    clayj

    Joined:
    Jan 14, 2005
    Location:
    visiting from downstream
    #2
    Be careful when copying... if you accidentally select an entire column of cells, that's potentially 65,536 cells that you're copying and pasting; it could take a while to process. Make sure you select only the actual cells that you want to copy, and not an entire column (or columns).

    The Find feature could be slow for the same reason... if you've accidentally activated an entire column of cells, then the number of cells that must be searched increases by a huge number. For example, if your sheet goes from A1 to J10, that's 100 cells; if it goes from A1 to J65536, that's 655,360 cells that must be searched.
     
  3. Macaddicttt thread starter macrumors 6502a

    Macaddicttt

    Joined:
    Apr 22, 2004
    Location:
    San Diego, CA
    #3
    No, that's not my problem. I'm sure I'm just copying one cell at a time.

    Well, I am trying to search the whole document. But the thing is, I did the same thing on a 700-and-something MHz Pentium-something Dell, and had no problems. No slowing down at all. It could search a whole document and find everything practically instantly (well, a few seconds).
     
  4. snkTab macrumors 6502a

    snkTab

    Joined:
    Nov 13, 2004
    Location:
    Cincinnati, OH
    #4
    Alert! Don't get a mac! They can't run excel.

    lol, anyway, Check to make sure you don't have anything thats constantly trying to update its value from a huge formula or anything.

    But really, probally just an issue with the mac version of excel with large files.
     
  5. oingoboingo macrumors 6502a

    oingoboingo

    Joined:
    Jul 31, 2003
    Location:
    Sydney, Australia
    #5
    Unfortunately I have also witnessed the slow-downs you describe (especially with cutting, pasting and deleting cells), and I have no idea what the problem could be. This is using Excel v.X on both my 1.33GHz 12" PowerBook (with 768MB RAM) and my 1.6GHz PowerMac G5 (with 1.25GB RAM). I'm not sure if there's something in particular (like autocorrect) that's turned on that's slowing down the whole thing, but the unfortunate truth is that Microsoft Office runs much more slowly on the Mac than it does on a similarly specced PC. Word even has trouble keeping up with my typing...on a G5 :(
     
  6. snkTab macrumors 6502a

    snkTab

    Joined:
    Nov 13, 2004
    Location:
    Cincinnati, OH
    #6
    woah! are you serious?
     
  7. oingoboingo macrumors 6502a

    oingoboingo

    Joined:
    Jul 31, 2003
    Location:
    Sydney, Australia
    #7
    Yes. It's not like Word drags half a paragraph behind or anything like that, but there are times (my personal theory on this is that Word's Autocorrect misfeature might be to blame) when the text doesn't appear on your document at a speed which you would expect. There is sometimes a small, yet perceptible lag between pressing a key and the text appearing on the document. This is on Word v.X with all the updates applied. It isn't bad enough to interfere with my work (not by a long shot), but like I said...the lag sometimes between striking a key and the letter appearing on screen is enough to easily notice. Microsoft Office on the Mac, while being completely usable (I use it every day), is definitely not as smooth a performer as it is on Windows.

    I also find in Keynote 1.1.1 that entering text into text boxes can be a bit laggy also, depending on what other elements are on the slide at the time. Nothing that stops me working...it's just noticeable, and you don't expect a 1.33GHz G4 PowerBook to struggle keeping up with typing :)
     
  8. ReanimationLP macrumors 68030

    ReanimationLP

    Joined:
    Jan 8, 2005
    Location:
    On the moon.
  9. oingoboingo macrumors 6502a

    oingoboingo

    Joined:
    Jul 31, 2003
    Location:
    Sydney, Australia
    #9
    Keynote has similar problems. What's your point?
     
  10. osiris315 macrumors member

    osiris315

    Joined:
    Apr 7, 2005
    Location:
    Valencia, Spain
    #10
    I am having exactly the same problems. Nearly new Dual 2.3 and running Office 2004 v.11.1.1.

    Trying to cut and paste single cells or even a line slows Excel down and I get the 'stopwatch' busy icon or sometimes even a beachball.

    Does anyone have any suggestions or ideas?
     
  11. mkubal macrumors 6502a

    Joined:
    Jul 22, 2002
    Location:
    Tampa
    #11
    I find that I have this problem the first time I cut/copy and paste. After that it works perfectly. Not sure why.

    I also have found that when you enable the saving of an auto recover file, the saving process takes longer and longer each time it saves even if you aren't adding very much data. I have files sometimes that are about a couple megs and after 5 hours of being open an auto save will take about 30 seconds. Way too long for a small file.

    Of course this is a minor annoyance compared to the other problems I have.

    Oh, and I'm using the most up to date version of Office.
     
  12. bellis1 macrumors 6502

    Joined:
    Feb 9, 2003
    #12
    iDisk

    Do you have idisk mounted automatically in finder? I was having a lot of problems with slowdowns because of this. Try unmounting and leaving it off and see if it helps. I can replicate this slowdown every time I turn it on.
     

Share This Page