If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Do I need a new PC? - Memory Error on 15000 lines of data
I am using 15000 lines of data over 20 columns. Then Im using
sumproduct to run several reports within tabs in the same workbook. My computer gets real slow then on save, I cannot because of the memory error. So, do I need a new computer. I have 1gb of ram now with an Intel Celeron processor at 1.8Mhz. Is it ram, processor speed, dual core or all 3 that would fix this? Any recommendations? |
#2
|
|||
|
|||
Do I need a new PC? - Memory Error on 15000 lines of data
Lots of recommendations here from Charles Williams... http://www.decisionmodels.com/memlimitsc.htm -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "wx4usa" wrote in message I am using 15000 lines of data over 20 columns. Then Im using sumproduct to run several reports within tabs in the same workbook. My computer gets real slow then on save, I cannot because of the memory error. So, do I need a new computer. I have 1gb of ram now with an Intel Celeron processor at 1.8Mhz. Is it ram, processor speed, dual core or all 3 that would fix this? Any recommendations? |
#3
|
|||
|
|||
Do I need a new PC? - Memory Error on 15000 lines of data
To actually test the physical RAM in the system, go to www.memtest.org and
download the file appropriate to your system -- one of the "Pre-Compiled Bootable ISO" files should work for you if you've got a Windows based system. Which depends on your uncompressing utility - if you don't have one, go to www.winzip.com and download the trial copy and use it to uncompress the .zip file. It will create a bootable medium for you, then you get your computer to boot from that medium (may require a BIOS boot device change). Run the test for as long as you can - it will run until you stop it. If there are actual errors in the memory, it will find them and report them to you. If it does, the fix is probably simple: replace the memory chip(s) with the error(s). "wx4usa" wrote: I am using 15000 lines of data over 20 columns. Then Im using sumproduct to run several reports within tabs in the same workbook. My computer gets real slow then on save, I cannot because of the memory error. So, do I need a new computer. I have 1gb of ram now with an Intel Celeron processor at 1.8Mhz. Is it ram, processor speed, dual core or all 3 that would fix this? Any recommendations? |
Thread Tools | |
Display Modes | |
|
|