Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel copy/paste slow
All of my excel files lock up when I try to copy a range of cells. This
happens on all of my files on my machine only. I have run an Office Repair, I've uninstalled and reinstalled and it is still happening. This does not appear to be an issue with any other Office program. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel copy/paste slow
Could you perhaps have a large chunk of data in your clipboard?
"plunk25" wrote: All of my excel files lock up when I try to copy a range of cells. This happens on all of my files on my machine only. I have run an Office Repair, I've uninstalled and reinstalled and it is still happening. This does not appear to be an issue with any other Office program. Any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel copy/paste slow
Just as a test try copying and pasting "values only" from the paste special
option. This should normally work very quickly. If it doesn't then there might be something wrong. if it does work fine, perhaps your problem is because of some crazy formating. Another thing to check, besides the clip board is the amount of memory that your file is eating up. try writing this in an empty cell =info("memused") this will return a number in bytes, if you want megabytes just divide by 1024 twice (ie x/1024/1024). this should be a small number, unless there's a lot of 'hidden' information on your spreadsheet (or you have a lot of graphs/embedded queries). if it is to high I remember seeing a macro to "delete unused" on this site. This might help by clearing up any information that excel could be keeping on your sheet. cheers "Tim M" wrote: Could you perhaps have a large chunk of data in your clipboard? "plunk25" wrote: All of my excel files lock up when I try to copy a range of cells. This happens on all of my files on my machine only. I have run an Office Repair, I've uninstalled and reinstalled and it is still happening. This does not appear to be an issue with any other Office program. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Excel 2003 Slow Start Up | Excel Discussion (Misc queries) | |||
Excel from e-mail attachment slow | Excel Discussion (Misc queries) | |||
why is excel so slow | Excel Worksheet Functions |