Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Possible to copy sheets into another (closed!) workbook?
Hi there
Would anyone know how I can copy some worksheets into another workbook which is closed. The files are so big that I can't open them both at the same time. Thank you very much! Manuel |
#2
|
|||
|
|||
Do it in batches.
Open bigfile1 and copy the sheets to a new workbook. Close bigfile1 and open bigfile2. Copy the sheets from newbook to bigfile2. Gord Dibben Excel MVP On 17 Feb 2005 16:25:39 -0800, "Grotifant" wrote: Hi there Would anyone know how I can copy some worksheets into another workbook which is closed. The files are so big that I can't open them both at the same time. Thank you very much! Manuel |
#3
|
|||
|
|||
Thanks a lot for your reply.
The problem is that I want to copy all sheets from bigfile2 into bigfile1 and I can't open them at the same time. Is there an upper limit of the max. filesize in excel? Together the files are around 90MB - but I thought that would be fine. Cheers, Manuel |
#4
|
|||
|
|||
You could try saving the worksheets as .csv - and then importing the
information. That way one of the 'big' files will be a 'not nearly as big' file. Then you just need to copy/paste special/formats so everything looks okay...hopefully. Having said that - if the workbooks are so big, have you considered an Access DB? "Grotifant" wrote: Hi there Would anyone know how I can copy some worksheets into another workbook which is closed. The files are so big that I can't open them both at the same time. Thank you very much! Manuel |
#5
|
|||
|
|||
Thanks a lot for your help - will try this. You're right, Access would
probably be a better solution but have never used it before... Greetings, Manuel |
#6
|
|||
|
|||
I'm not a huge Access user myself, but for massaging large chunks of data,
with basic sort facilities, it seems made for the problem you describe. It is not too difficult, with a table representing a worksheet, importing from one to another should not be a problem. Good luck. "Grotifant" wrote: Thanks a lot for your help - will try this. You're right, Access would probably be a better solution but have never used it before... Greetings, Manuel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Problems... | Excel Discussion (Misc queries) | |||
Copy with link between sheets - all the formats dissapear?!? | Excel Discussion (Misc queries) | |||
Copy comments to several sheets in a workbook? | Excel Worksheet Functions | |||
copy a workbook from other workbook with lot of sheets wit... | Excel Discussion (Misc queries) | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions |