Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
jknicely
Posted - 09/30/2015 : 11:03:56 PM Origin 2015. Windows 8.1. Microsoft Excel 2010.
I have to transfer large amounts of data from Excel files to Origin and then create plots of the data. I do this by copy/pasting from Excel into an Origin workbook. I need to do this several times a day for my work.
I have found that for some of the large data sets, this causes Origin (and sometimes Excel) to freeze for long periods of time (as long as 2 hours, though usually around 30 min). The block of data is typically 30000 rows and 20 to 40 columns. While copying, I've found Origin uses over a gigabit of RAM and maxes out my Disk. I've noticed it's less of a problem immediately after restarting my computer. This would lead me to believe RAM is an issue, but my computer has 4 gigs of it.
Why does this happen?
Are there any ways to speed up this process?
Would importing the Excel file be better?
1 L A T E S T R E P L I E S (Newest First)
Hideo Fujii
Posted - 10/01/2015 : 2:30:27 PM Hi jknicely,
> Why does this happen? > Are there any ways to speed up this process? > Would importing the Excel file be better?
Yes, I believe that importing Excel file first into an Origin worksheet improves the performance. Could you please try?