Not enough memory

[Edward Ulle]

I am running into a problem loading data into Excel.

First is there a limitation on the number of Worksheets (i.e. 256)?

Secondly, I am getting the message Not enough memory. If I use
Application.MemoryTotal it says only 1.5 mBytes and MemoryFree 1.0
mBytes. Numbers seem very low by todays expectations.

I have not tried VBA for Access but would this get around the memory
limitations and could I program some thing equivalent to a Chart to plot
this data?

TIA

 

[Guest]

Here is everything you want to know about Memory. There is also a good
section on perfomance and Calculations...

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

 

[Edward Ulle]

Jim,

The articles talk about 80 mBytes for Excel 2000 whereas
Application.MemoryTotal says only 1.5 mBytes. Am I missing some setting
to increase the memory available to Excel?

Thanks

 

[Guest]

Take a look at your Task manager to get a good handle on usage. Some
operations just use a lot of memory.

 

[Charles Williams]

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