Tom's Hardware > Forum > General UK & Ireland Discussions > what spec for excel ???

what spec for excel ???

Forum General UK & Ireland Discussions : what spec for excel ???

Related Content

You have searched for "what spec for excel ???" . You might be interested in the following threads:

Can anyone tell me what is the best spec for my needs.

I only use a computer for spreadsheet use.
I have 10 sheets open in one workbook.
Sheets are over 50,000 rows deep and 30 columns wide.
Array formulas run down several columns.

When I run macro to fill down array formulas the machine freezes.
Computer is AMD Athlon(tm) XP 2600+.

I have maximum of £400 but don't require monitor.

Any suggestions??
Thanks.
Colwyn.

Reply to colwyn

how much memory do you have and how much are you using (task mamager). Is the Harddrive trashing away to itself?

Memory might be the limiting factor, and patience.

I've worked with similar sizes on a little laptop with only 512Mb back in 2003. Turn off screen updates as the first thing in the macro, turn them back on at the end. I also ended up implementing a little timer, that turned screen upadtes back on again on a blank sheet with a simple formula that showed how long it has been running for and updating it every 1000 iterations or so, hence every time it updates you know it is still doing something and hasn't stalled.

Reply to 13thmonkey

email enabler, ignore this post

Reply to 13thmonkey

13thmonkey, thanks. Have 1Gb of DDR SDRAM.
Tried the turn off screen updating in macro but waited over an hour and still frozen up.
Be interested in the macro/formula you devised for showing how long it was running.
Colwyn.

Reply to colwyn

at the start I just set a single cell to =now() say a1

Then every 1000? interations I turn on screen updating set b1=now()-a1 then i turn screen updating off again. Do this on a blank sheet, and format b1 as hh:mm:ss

Also turn calculations off as well and then just do the on lot of re-calcs at the very end.

Have you checked task manager to see memory usage, and is the HDD trashing away to itself. If they are then you'll get a lot more benefit from more memory. Process spped increases will merely decrease the time to running out of memory and then grinding to a halt as the HDD comes into play.

won't be on line for a few days, if the clock keeps ticking away, go to the pub till its complete, you could even include a counter to tell you where it has got to, i.e. which sheet and which line it is entering. let me know what task manager tells you, cpu temps might be good to monitor too.

Message edited by 13thmonkey on 10-01-2008 at 06:04:56 PM

Reply to 13thmonkey

This topic has been closed by Mousemonkey

------------------------------

http://www.st-owners.com/forums/images/smilies/bl11.gif

Reply to mousemonkey

Related content

See all topics related to "what spec for excel ???"

Tom's Hardware > Forum > General UK & Ireland Discussions > what spec for excel ???

Go to:

There are 731 identified and unidentified users. To see the list of identified users, Click here.

Bestofmedia Forum ©
2000-2009 Bestofmedia Group

Page generated in 1.891 seconds

Please mind

You are about to answer a thread that has been inactive for more than 6 months.
If you still wish to proceed, please ensure that your posting is original and does not duplicate or overlap any prior responses to this thread.

Add a reply Cancel

Latest best answer

Fake Windows XP disk

By Rusting In Peace, 244 days ago:

Perhaps you missed what das_stig wrote: "you must have the key on a sticker...

They won a badge

Join us in greeting them

17:08 aoaom won the Freshman badge
16:27 wuyu2241 won the Freshman badge
15:01 Cooky1992 won the Uniformed badge
15:01 medu5a won the Uniformed badge
15:01 mefa_star won the Uniformed badge
15:01 C4ptainpanda won the Uniformed badge
11:45 googlman won the Freshman badge
04:50 underwater mike won the Uniformed badge
04:40 tomstoms won the Freshman badge
04:24 dibetter won the Freshman badge

How do I win badges?

Partners