ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What kind of memory does not enough? (https://www.excelbanter.com/excel-discussion-misc-queries/156845-what-kind-memory-does-not-enough.html)

Eric

What kind of memory does not enough?
 
Does anyone have any suggestions on what kind of memory it is?

There is a table A1:Z4000, when I select this table and replace $L with $U,
the speed of running through the table is very quick from A1 to B3000, but it
runs very slow from B3000 to Z4000, and pop up a window for enough memory.
Does anyone have any suggestions on what kind of memory it is?
I get 2GB RAM and 4.65 GB free space on HDD.
Thanks you for any suggestions
Eric

JMB

What kind of memory does not enough?
 
Charles has some good information on his site:

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


"Eric" wrote:

Does anyone have any suggestions on what kind of memory it is?

There is a table A1:Z4000, when I select this table and replace $L with $U,
the speed of running through the table is very quick from A1 to B3000, but it
runs very slow from B3000 to Z4000, and pop up a window for enough memory.
Does anyone have any suggestions on what kind of memory it is?
I get 2GB RAM and 4.65 GB free space on HDD.
Thanks you for any suggestions
Eric



All times are GMT +1. The time now is 10:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com