memory problem with excel
 

I use many years Excel but for the first time began to use in suc
scheme:
File Excel is open round the clock, the computer is swith o
continuously.
In this file is Macro which prepares for a text file. Other my progra
written on Visual Basic and MATLAB also it is active continuously an
uses this text file.
The problem in that after day or sometimes more a computer hangs, a
though resources of memory are completely spent and it ceases
to react to commands from the keyboard and a mous.
I shall be very grateful if who that will explain to me why it occur
and as with it to struggle.

Valery Belfor

:

--
Message posted from http://www.ExcelForum.com

memory problem with excel
 

Round the clock operation would be my guess. you did not
say why the file needs to be open round the clock. If it
is a life and death situation, I would look for another
method. If it is not a life and death situation, I would
schedual down time to clear memory. You mentioned runing a
macro but did not say what the macro does. Depending on
what the macro is doing, it could be what is filling up
your memory via the clipboard. I know of no real answers
for you that would allow you to operate round the clock.
-----Original Message-----
I use many years Excel but for the first time began to
use in such
scheme:
File Excel is open round the clock, the computer is
swith on
continuously.
In this file is Macro which prepares for a text file.
Other my program
written on Visual Basic and MATLAB also it is active
continuously and
uses this text file.
The problem in that after day or sometimes more a
computer hangs, as
though resources of memory are completely spent and it
ceases
to react to commands from the keyboard and a mous.
I shall be very grateful if who that will explain to me
why it occurs
and as with it to struggle.

Valery Belfor

:)


---
Message posted from http://www.ExcelForum.com/

.

memory problem with excel
 

valery8 wrote:

I use many years Excel but for the first time began to use in such
scheme:
File Excel is open round the clock, the computer is swith on
continuously.
In this file is Macro which prepares for a text file. Other my program
written on Visual Basic and MATLAB also it is active continuously and
uses this text file.
The problem in that after day or sometimes more a computer hangs, as
though resources of memory are completely spent and it ceases
to react to commands from the keyboard and a mous.
I shall be very grateful if who that will explain to me why it occurs
and as with it to struggle.

Valery Belfor

:)


---
Message posted from http://www.ExcelForum.com/

Try the following benchmark.
Pop up your Task Manager and switch to the Performance pane.
Or use any other resource monitoring software "out there", if you like.

Open Excel. Open your file and close it, but don't close Excel. Repeat
this about 10-20 times and keep watching the performance.

Now close Excel and re-open. Repeat this also a few ten times.
Now do the same with some other apps: Explorer, Internet Explorer,
Word, Outlook, some non-MS apps: open and close them a few times. Keep
watching the performance.

What you should notice after a while, is a slow but steady drop in
resources. This phenomenon is intrinsic to the Microsoft Windows
platform. The newer your Windows, the less you experience this problem.
For example: it was almost impossible to run Windows 98 longer than 2
days in a row if you started and stopped a lot of programs. Windows
2000 can run a few weeks in a row without hiccups and Windows 2003
should last for months.

--
Amedee Van Gasse using XanaNews 1.16.3.1
If it has an "X" in the name, it must be Linux?