Excel 2004 for Mac is to slow and woks bad

[Fergus62]

I am and old user of Mac and work very much with excel. The excel
version that I used in my previous ibook worked much better than this,
and so does the excel in PC. I looked in get info to increase the
memory asigned to excel, like usually, but it seems that Tiger does it
automatically. ¿It can be changed? I can´t believe that I have to
work like this, maybe somebody can tell me what can I do to solve this.

 

[Jim Gordon MVP]

Hi Fergus,

There are two version of Excel for Tiger: Excel version X and Excel
2004. Which one are you using?

I don't know what you mean by "worked better." Better in what ways?

MacOS now manages memory for ALL applications, not just Excel. This is
not a feature that can be altered in MacOS. You never have to set memory
allocations in GET INFO. MacOS does it for you automatically, all the
time, on the fly. Are you getting a message that says you don't have
enough memory installed?

-Jim

 

[Fergus62]

I have Excell 2004, and have been using excel for 20 years. This is the
worst of all! I can´t believe it can be true, there may be something
to do! The excel makes many mistakes, like: in some cases asignes to
much free rows and columns for that I am using (like 16000 rows and I
use 700), often I select "copy" and "thinks" until continue, in one
specific sheet when I press "show all" it stops working and I have to
force quit excel, and several others, sometimes have problems to insert
rows or to paste in many rows at once when I have copy one row...Works
really bad!

 

[Bob Greenblatt]

I have Excell 2004, and have been using excel for 20 years. This is the
worst of all! I can´t believe it can be true, there may be something
to do! The excel makes many mistakes, like: in some cases asignes to
much free rows and columns for that I am using (like 16000 rows and I
use 700), often I select "copy" and "thinks" until continue, in one
specific sheet when I press "show all" it stops working and I have to
force quit excel, and several others, sometimes have problems to insert
rows or to paste in many rows at once when I have copy one row...Works
really bad!

Well, my experience with Excel 2004 is just the opposite of yours. @004
works better than most prior versions. I think you may have some kind of
configuration issue. Your description sounds like you may have a corrupt
work book. Try pressing control-End to go to the last cell. If this cell is
much further below and to the right from where you think it ought to be then
delete the extra rows and columns. Then SAVE and CLOSE the workbook. When
you reopen it it should perform much better.

 

[Fergus62]

Bob,
I did what you tell me (a sheet has 65476 rows and IV columns, I only
need 1000 and AZ), but when I select de rows and delete them, nothing
hapens!

 

[Bob Greenblatt]

Bob,
I did what you tell me (a sheet has 65476 rows and IV columns, I only
need 1000 and AZ), but when I select de rows and delete them, nothing
hapens!

You have to select them delete them and then SAVE AND CLOSE the workbook. It
should be OK when you reopen it.