Technical Excel help needed.

[Re83L]

Hi guys..

I work in insurance, and typically work with enormous Excel spreadsheets, many of 50MB and over.

I'm going insane, I have a quad-core Q6600 at work with 2GB RAM and running XP.
The file I've been working with today has frozen about 15 times today, each time I lose a lot of work..
I'm basically busy with a grid of about 40 000 lines, where I use vlookup,match sumifs, countifs etc.
Every time I complete a value, I paste-value the results to overcome all the re-calculation problems..

Automatic calulation is already off, so is autorecover saves..
Yet when I try and copy a formula down 40 000 cells, my computer frequently hangs.

My pagefile usage is at 0.99GB, and CPU and memory usage looks fine. (CPU 25%, memory 70% used)

Can anyone maybe help with a solution?
Thanks guys, this' really getting to me..

 

[Re83L]

I started out by manually setting my pagefile to a minimum size of 4GB, with a maximum of 10GB.

Hopefully this works..

 

[dequadin]

Which version of excel are you using?

I know you can put a lot more data into a 2007 spreadsheet, so 2007 should handle it better. (but common logic never prevails....)

 

[Re83L]

Which version of excel are you using?

I know you can put a lot more data into a 2007 spreadsheet, so 2007 should handle it better. (but common logic never prevails....)

Yep, sorry, excel 2007..

 

[remybfg10k]

When pasting or doing the vlookup etc, what increments does the Calculating on the bottom right show?