| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
memory problem of Excel 2003 copy & paste
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! |
|
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
|
memory problem of Excel 2003 copy & paste
Some things... Did you have this problem before you installed XL2007? Do you have XL2007 installed in the same folder as XL2003? Are you running both Excel versions at the same time? Is the copy and paste done using the keyboard or VBA code? What is the file size? Have you cleared the Windows temp folder? Is your anti-virus program scanning Excel when you copy and paste? "LunaMoon" wrote in message 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! |
|
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
|
memory problem of Excel 2003 copy & paste
Try Edit, Office Clipboard, Clear All.
If that won't work try the steps outlined by BR and JJ. Peter Atherton "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! |
|
#5
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
|
memory problem of Excel 2003 copy & paste
Pagefile (or Virtual memory) can be a real pain if not set up right. It
should be at least 1.5 times the actual memory. At windows installation it is set to 1.5 times actual memory by default and this is OK. If you increase the physical memory size, windows does not necessarily increase the Pagefile size. Check as follows: Windows XP: Open Control Panel - System - Advanced Tab - Performance Settings - Advanced Tab Windows Vista: Open Control Panel - System - Advanced System Settings - Performance Settings - Advanced Tab Check the size of the virtual memory and change to at least 1.5 times your actual physical memory. That is 1500MB if you have 1000MB (1GB) memory. Also lookup pagefile in windows help and see if any if the things mentioned there could apply to your situation. I am not full bottle on all the reasons but I am told that if there is insufficient space in the Pagefile to temporarily hold all the actual memory, windows swaps it out in dribs and drabs and it takes forever; but don't quote me on that because it is only hear say. Also note the other replies because it could be any reason. -- Regards, OssieMac "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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| memory problem of Excel 2003 copy & paste | Excel Discussion (Misc queries) | |||
| Excel 2007/2003 compatibility problem - copy and paste | Excel Discussion (Misc queries) | |||
| Copy and paste problem Excel 2003 to Word 2003 | Excel Discussion (Misc queries) | |||
| Copy/Paste - Running out of Memory | New Users to Excel | |||
| VBA Code runs out of memory - too much copy/paste? | Excel Programming | |||
Hybrid Mode
