Excel 2003, Out of memory 1

[LordMaximus]

Hi people

Gonna need some help on this one. One of my users has a 60MB excel spreadsheet with more than 63000 lines. (I got no idea what data this is, but it's alot). Anyways, when opening, the sheet starts loading and you can see the values, then all of a sudden it stops with a error : "Out of memory"

The values then just turns into ##### 's

Is there a way to increase the number of cells in Excel?

Please help

Thanks

 

[jonsi]

I'm not surprised you get that message. If you're looking for more than 63,000 rows of data then Excel really is the wrong app. This size DB shold be using Access or similar.

 

[dhulbert]

maximuns

The number of rows in Excel is fixed there's nothing you can do about that.
The only thing you could try is either reducing the size of the spreadsheet, or increasing the amount of memory you have in the machine.

 

[LordMaximus]

The machine's got 512MB of memory. The exact error message is : "Excel cannot complete this task with available resources" and excel uses approx 41mb of memory.

 

[dhulbert]

Is it linked to other spreadsheets ? If it is you could open then first that will sometimes help with the problems other then that then jonsi's right you really need to look at staring the data in a more suitable format.

 

[KenWright]

Excel has it's own internal memory limits. See here for more info:-

http://www.decisionmodels.com/memlimits.htm

http://www.decisionmodels.com/memlimitsb.htm

http://www.decisionmodels.com/memlimitsc.htm

http://www.decisionmodels.com/memlimitsd.htm

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[LordMaximus]

Thank you everybody for the help.
I find my answer in one of the links supplied by KenWright