excel issues

[rmvworld]

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

I've recently migrated from a PC to a MAC to try Macs challenge to the PC. Having been a PC user for 20 yrs, YES 20 yrs... i decided its time i give MAC a go and see if it stumps up.

My business relies heavily on excel so i migrated my worksheets to MAC. The average file is about 6-8 mb big with about 200 worksheets plus in each file.

I find the MAC unable to keep up firstly on my brand new mac (4gb ram, latest config being sold on the market with a 24 inch screen)... also its frustrating the system or more like EXCEL just "jams: up" i cant do anything except force quit and little things like adding a little graphic file sends MAC into a frenzy and leaving it for 10 mins does nothing.

Clearly the excel for mac cant handle the data.. which is misleading cos the advertisements show differently.

Unless i find a way to improve this, my mac is proving already to be a bad investment. Of course i am new to it, so it could require tweaking. anyone out there can help?

 

[Jim Gordon MVP]

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

I've recently migrated from a PC to a MAC to try Macs challenge to the PC. Having been a PC user for 20 yrs, YES 20 yrs... i decided its time i give MAC a go and see if it stumps up.

My business relies heavily on excel so i migrated my worksheets to MAC. The average file is about 6-8 mb big with about 200 worksheets plus in each file.

I find the MAC unable to keep up firstly on my brand new mac (4gb ram, latest config being sold on the market with a 24 inch screen)... also its frustrating the system or more like EXCEL just "jams: up" i cant do anything except force quit and little things like adding a little graphic file sends MAC into a frenzy and leaving it for 10 mins does nothing.

Clearly the excel for mac cant handle the data.. which is misleading cos the advertisements show differently.

Unless i find a way to improve this, my mac is proving already to be a bad investment. Of course i am new to it, so it could require tweaking. anyone out there can help?

Hi

The first thing to check is if Excel is up to date. On the Excel menu
choose About Excel. It should say Latest Installed Update 12.2.1

If it's not up to date, use the Help menu to check for updates.

-Jim

 

[John McGhie]

Hmmm....

I have a 12 MB spreadsheet here I use for testing. It has a formula in
every cell of a 200 x 4,000 sheet.

I just jammed a picture in the middle of it.

OK, it's not the fastest sheet I have, but recalc takes only about three
seconds... No hangs or freezes or crashes.

Excel for the Mac can handle the data: it won't be as quick as Excel on the
PC because it is new code that still needs some optimisation.

But it will do a lot better than that.

If you intend to use the machine for heavy work, I would throw it another
4GB of RAM

Cheers

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

I've recently migrated from a PC to a MAC to try Macs challenge to the PC.
Having been a PC user for 20 yrs, YES 20 yrs... i decided its time i give MAC
a go and see if it stumps up.

My business relies heavily on excel so i migrated my worksheets to MAC. The
average file is about 6-8 mb big with about 200 worksheets plus in each file.

I find the MAC unable to keep up firstly on my brand new mac (4gb ram, latest
config being sold on the market with a 24 inch screen)... also its frustrating
the system or more like EXCEL just "jams: up" i cant do anything except force
quit and little things like adding a little graphic file sends MAC into a
frenzy and leaving it for 10 mins does nothing.

Clearly the excel for mac cant handle the data.. which is misleading cos the
advertisements show differently.

Unless i find a way to improve this, my mac is proving already to be a bad
investment. Of course i am new to it, so it could require tweaking. anyone out
there can help?

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

--

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]