Posted: 10/11/2015 5:19:56 PM EDT
|
I have some sets of data that are about 50 columns by 1600 - 2000 rows in individual excel files. In attempting to add sequential data sets into one large excel file, I am having trouble with "copy paste" of one data set (from an excel file) and inserting it into another excel file.
For some reason it won't copy into my new file. Any tips on what I could try to get this to work for me? Thanks |
|
Do you have both sheets ETA workbooks open in one instance of excel or are they open in two different excel instances? If they are in two different instances (you can see both workbooks at the same time in different windows) it fucks up copy - paste. Open them both in one window and it should fix it. |
|
Each data set would open in a new workbook (as one sheet only), but when I copied the sheets into a new workbook, not even then could I copy paste the data onto a worksheet (with only one instance open).
Unless anyone has a better idea, I've been opening the worksheets as a table in matlab then adding the data in, and exporting as an excel file. Which is going to take too much time. |
|
How long are you waiting in between copy and then trying to paste? I routinely copy and paste really large chunks into and out of excel, SAS, SPSS and/or teradata sqla and if systems resources are low it takes a while to copy to the clipboard and then back out. I usually give it a minute or so between steps if I run into issues like that. Could just be a placebo effect, but it works for me.
eta- that amount is trivial now that I see it wasn't 160000! ,have you tried a full restart? |
|
Quoted:
I have some sets of data that are about 50 columns by 1600 - 2000 rows in individual excel files. In attempting to add sequential data sets into one large excel file, I am having trouble with "copy paste" of one data set (from an excel file) and inserting it into another excel file. For some reason it won't copy into my new file. Any tips on what I could try to get this to work for me? Thanks Have you looked to see that both workbooks are saved as the same version of excel? |