Excel limits?

[Expiry]

I'm not scared...

I ran the code and got to Book697, before, I got the following message.

"Excel cannot complete this task with available resources. Choose less data or close other applications."

The only Apps open was an RDP link to an external server.

Oh, and I have 12GB of RAM onboard.

Well done. You've set the bar pretty high.

 

[arkusM]

I'm not scared...

I ran the code and got to Book697, before, I got the following message.

"Excel cannot complete this task with available resources. Choose less data or close other applications."

The only Apps open was an RDP link to an external server.

Oh, and I have 12GB of RAM onboard.

My clunker made it to 727, only 1 GB of Ram... it took a long, long time.
Excel 2003.
Excel was the only user initiated program, and whatever default stuff that out IT runs on our boxes.

 

[Norie]

That's nothing, I got to 42.

Probably could have got further but I got bored and tried to CTRL+BREAK it.

Excel greyed out, stopped responding, wanted to fix the problem, send a report etc so I shut it down humanely with Task manager.

 

[number kruncher]

Maybe the RAM amount has no bearing on this?

My setup is..

Windows 7 64Bit
Excel 2007

 

[Expiry]

My work laptop is only one upgrade away from an etch-a-sketch and it took about 20 minutes to get to 616.

I didn't get an error message, it just kind of submitted.

 

[JamesW]

Is this going to be a new MrExcel competition?

 

[Sandeep Warrier]

I tried Jon's code twice..... it first went upto 79 and then to 38....

 

[Jon von der Heyden]

I tried Jon's code twice..... it first went upto 79 and then to 38....

And tell the board Sandeep, where is your nice new i7 at the moment?

 

[Sandeep Warrier]

And tell the board Sandeep, where is your nice new i7 at the moment?

It's an i5 .... though where it is at present is still a question!

 

[SydneyGeek]

My new toy's an i7 with 8GB RAM

Denis