memory problem of Excel 2003 copy & paste
Please show your code. There may be ways to speed it up.
Barb Reinhardt
"LunaMoon" wrote:
Hi all,
I am using Excel 2003 for some project.
I am having 2GB C drive harddisk space.
After a while, the Excel begins to be extremely slow in copy and
paste...
It takes about half an hour to copy and paste just a few cells...
I've consulted people. It seems a memory problem.
But I cannot close my windows and kill the processes, because I am
running long-running (overnight) jobs...
I cannot reboot either.
Is there a way to clean the memory and let Excel 2003 clipboard
function properly without rebooting or killing my 4 long-running
processes?
Thanks!
p.s. I am sure this is an issue due to the special clipboard feature
of Excel 2003. It's very weird, is there a way to get rid of that
feature?
When the copy&paste was hung, I also checked the task manager, and
found no CPU usage for this particular operation, every single
copy&paste will cost me 30 minutes. And my colleagues are having the
same problem.
They say the only way out for them was to reboot...
How stupid is Excel 2003!
|