Memory Problem?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Having some problems with entering data in Excel. Symptom is when enter data
in one column, its mirror image was not showing up in different column
(using:
=IF(J9="","",IF(LEN(J9)>3,AV9,UPPER(AV9)))

Other intermittant symptoms: - Conditional Formating was not changing color
in either column, intermittantly.
- Delete data from 1st column & intermittant: either mirror text does not
go away, or conditional formats remained color, in changed, unchanged,
intermittant fashion.

SOME SETTINGS INCLUDE:
MEMORY: 128 MB
PAGE FILE: was set at 400MB max 800 MB, changed to automatic
OPTIONS, calculations, MAX ITERATIONS: 20 MAX CHANGES: 10

Is there advice I can get for computer settings, in general, and to help
with this situation?

Any recommendations on Memory Utilities will be greatly appreciated. Thanks.
 
What version of Windows are you running? What CPU speed?
How large is your hard disk and how much free disk space?


--

Hope this helps.

Gerry
~~~~
FCA
Stourport, England

Enquire, plan and execute
~~~~~~~~~~~~~~~~~~~
 
Hi nastech,
It's looks like MS office Bug case,please send your problem or make your
post to the MS office newsgroup,they will be much of help to you,unless
somebody here with good knowledge on MS office and spot your post and give
you an idea or solution.
good luck.
nass
 
oops, sorry, don't know if you wanted reply, or if xp/hardware/office
problem, just getting any ideas. here is the info you asked, for? thanks.

COMPUTER: DELL Dimension 4300
Processor: Intel(R) Pentium(R) 4 CPU 1.60GHz
Processor Speed: 1.56 GHz
Memory (RAM): 128 MB
Memory Type:
OS: Microsoft Windows XP Home Edition
OS Version: 5.1.2600
Hard Drive: 37.22 GB, USED: 27 GB, FREE: 10.22 GB

Page File: was set at 400MB max 800 MB, changed to automatic
Options, calculations, MAX ITERATIONS: 20 MAX CHANGES: 10 (excel)
 
sorry, forgot: maybe cause of some script in sheet also. will check. thanks
in case wanted to know, helps, date script:

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count > 1 Then Exit Sub
If Target.Row < 24 Then Exit Sub
'just a dot?
if me.cells(.row,"A").value = "." then exit sub
'or contains a dot?
if instr(1,me.cells(.row,"A").value,".",vbtextcompare) > 0 then
exit sub
End if
If Not Intersect(Me.Range("AJ:AJ"), .Cells) Is Nothing Then
Application.EnableEvents = False
With Me.Cells(.Row, "AG")
.NumberFormat = "dd"
.Value = Now
End With
Application.EnableEvents = True
End If
If Not Intersect(Me.Range("AO:AR"), .Cells) Is Nothing Then
Application.EnableEvents = False
With Me.Cells(.Row, "AW")
.NumberFormat = "dd"
.Value = Now
End With
Application.EnableEvents = True
End If
End With
End Sub
 
You either need to add more RAM memory or you have understated
what you have got! For Windows XP you probably need 512 mb.

You may check on pagefile (virtual memory) usage with Page File Monitor for
XP:
http://www.dougknox.com/

Make sure you study the readme.txt file carefully to ensure
you get the utility to work as it should.

With so little RAM memory do not set a maximum for pagefile.

http://aumha.org/win5/a/xpvm.htm


--

Hope this helps.

Gerry
~~~~
FCA
Stourport, England

Enquire, plan and execute
~~~~~~~~~~~~~~~~~~~
 
For advice on Excel post here:
microsoft.public.excel.programming

--

Hope this helps.

Gerry
~~~~
FCA
Stourport, England

Enquire, plan and execute
~~~~~~~~~~~~~~~~~~~
 
problem resolved, 2 items I may have posted actually had faults induced
recently.
=IF(J9="","",IF(LEN(J9)>3,AV9,UPPER(AV9)))

acidently chose j9, if empty, is cell where equation resides...
date script was re-written, got origin / destination cells out of synch.

memory was copy-paste and (besides when can correct) was issue couldn't find
answer to, until found this site, and subsequently found other answers,
during search.. memory answers were / will help. thanks.
 
Back
Top