Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Trouble copying worksheets between books - is there size limit?
I have a large workbooks (2mb) & another at 300kb . Recently I've been
unable to copy worksheets between them. There are a lot of named ranges - not sure if this is hampering. Could the problem be either size or named ranges? |
#2
|
|||
|
|||
"kris2u" wrote in message
... I have a large workbooks (2mb) & another at 300kb . Recently I've been unable to copy worksheets between them. There are a lot of named ranges - not sure if this is hampering. Could the problem be either size or named ranges? Kris, You might try moving them. I've had luck doing it this way with large files. After you move it from the source file to the destination file, close the source file w/o saving changes. That way it will still be in the source file when you open it the next time. JUST MAKE SURE THAT YOU SAVE THE SOURCE FILE BEFORE MOVING. If you have made changes to the source file before moving the sheets, you will lose those changed if you close the file w/o saving after moving the sheets. Also, you might have to go in and reset you named ranges after moving. I've notice that after moving (copying) a sheet, I can't see the named ranges on the copied sheet from the other sheets in the file. I hope that helps, Conan Kelly |
#3
|
|||
|
|||
Thanks very much for the help. I really appreciate it!
"Conan Kelly" wrote: "kris2u" wrote in message ... I have a large workbooks (2mb) & another at 300kb . Recently I've been unable to copy worksheets between them. There are a lot of named ranges - not sure if this is hampering. Could the problem be either size or named ranges? Kris, You might try moving them. I've had luck doing it this way with large files. After you move it from the source file to the destination file, close the source file w/o saving changes. That way it will still be in the source file when you open it the next time. JUST MAKE SURE THAT YOU SAVE THE SOURCE FILE BEFORE MOVING. If you have made changes to the source file before moving the sheets, you will lose those changed if you close the file w/o saving after moving the sheets. Also, you might have to go in and reset you named ranges after moving. I've notice that after moving (copying) a sheet, I can't see the named ranges on the copied sheet from the other sheets in the file. I hope that helps, Conan Kelly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
zero value when copying cells between worksheets | Excel Discussion (Misc queries) | |||
copying addresses from one workbook to another into several worksheets | Excel Worksheet Functions | |||
Copying multiple Worksheets | Excel Discussion (Misc queries) | |||
Copying Numerical Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) | |||
copying cells from other worksheets | Excel Discussion (Misc queries) |