it *is* a slow program.. tho seems slower on yours then mine.
else.. don't know what to say. I'll tell the client to try the updated version and give me their specs.
it *is* a slow program.. tho seems slower on yours then mine.
else.. don't know what to say. I'll tell the client to try the updated version and give me their specs.
It seems that the size of the file is the limiting factor. It's been 22 minutes and is only up to 850 rows on Excel 2004.
I will try to limit the rows to about 2000 and see what happens.
Software: LibreOffice 3.3 on Mac OS X 10.6.5
(retired Excel 2003 user, 3.28.2008 )
Humanware: Older than dirt
--------------------
old, slow, and confused
but at least I'm inconsistent!
Rich
Also, I noticed that when I tried to Exit, if there were few files, the Exit worked as expected. But I finally pulled the plug on the Excel 2004 after 25 minutes, but the Exit button didn't stop it. After 4 times of trying to stop it, I had to Force Quit Excel.
Now I am trying it with 2500 rows. In 8 minutes it has exported 350 rows. So a little faster.
If you don't mind I might look at the code tomorrow night, just to take a gander at what is going on.
Software: LibreOffice 3.3 on Mac OS X 10.6.5
(retired Excel 2003 user, 3.28.2008 )
Humanware: Older than dirt
--------------------
old, slow, and confused
but at least I'm inconsistent!
Rich
There must be something affecting the OS X version. Here are the results from 2500 rows of data, with seven columns selected:
Excel 2001 (OS 9.2.2) - 15 minutes completed and properly formatted in Word 2001
Excel 2004 (OS X 10.3.4) - at 35 minutes but only 44% complete
Thus a version running on a platform whose processor is 4 times slower about 40% less RAM out performs the faster processor by a wide, wide margin.
Now I am curious about the code itself. I don't have time tonight, but will examine it.
Software: LibreOffice 3.3 on Mac OS X 10.6.5
(retired Excel 2003 user, 3.28.2008 )
Humanware: Older than dirt
--------------------
old, slow, and confused
but at least I'm inconsistent!
Rich
Final results (both using 2500 rows - identical):
Excel 2001 (OS 9.2.2) - 15 minutes completed and properly formatted in Word 2001
Excel 2004 (OS X 10.3.4) - at 1 hour and 22 minutes properly formatted in Word 2004
Thus a version running on a platform whose processor is 4 times slower about 40% less RAM out performs the faster processor by a wide, wide margin (5 times faster on the slower machine).
Software: LibreOffice 3.3 on Mac OS X 10.6.5
(retired Excel 2003 user, 3.28.2008 )
Humanware: Older than dirt
--------------------
old, slow, and confused
but at least I'm inconsistent!
Rich
strange...
hmm - I did think the client once mentioned it locking up.. but it's not really.... Now - is it Excel or the OS???
A Microsoft statement regarding ODBC drivers:
<http://www.microsoft.com/mac/product...4/xl_ODBC.xml>
Software: LibreOffice 3.3 on Mac OS X 10.6.5
(retired Excel 2003 user, 3.28.2008 )
Humanware: Older than dirt
--------------------
old, slow, and confused
but at least I'm inconsistent!
Rich
nope - bad link
hhm - I thought I had posted another message.. specs from the client....
Mac
10.3.4
Office
X
I edited the list down the the first four items on the list and hit
'Export'. That was 19 minutes ago and I'm still waiting.
You did - post # 15.Originally Posted by starl
Something else must be going on. I know that with 20 items, it was done in less than 5 sec. Even on the older machine with 2001 it was still less than 10 sec.I edited the list down the the first four items on the list and hit
'Export'. That was 19 minutes ago and I'm still waiting.
I had other projects in the fire over the weekend - mostly theology, so I'll look again tonight at this one.
Software: LibreOffice 3.3 on Mac OS X 10.6.5
(retired Excel 2003 user, 3.28.2008 )
Humanware: Older than dirt
--------------------
old, slow, and confused
but at least I'm inconsistent!
Rich
Okay, I pared the list in Excel down to 1,000 rows with 7 columns of data. It took exactly 7 minutes to do it - this with OS X 10.3.4 and Excel 2004.Originally Posted by starl
Next I will try with 1,000 rows and 62 columns of data.
Software: LibreOffice 3.3 on Mac OS X 10.6.5
(retired Excel 2003 user, 3.28.2008 )
Humanware: Older than dirt
--------------------
old, slow, and confused
but at least I'm inconsistent!
Rich
Interesting: this time with 1,000 rows and selecting all 62 columns - 5 min. 42 sec. I assume that is because it doesn't have to filter any of the columns.
One question - once the client begins the process do they then work on other tasks in other programs? (Safari, Entourage, etc.) The reason I ask is that changing programs in the midst of it might slow down the process considerably. In fact, the other night I used one small program, switching out of Word, and the time was excessively long.
I will try the 25000 rows now with 62 columns. Then I will try it with activating other programs than Word to see what happens.
BTW, each time I run this I use a new copy of the original sheet, so that they all are "starting from the same point".
Software: LibreOffice 3.3 on Mac OS X 10.6.5
(retired Excel 2003 user, 3.28.2008 )
Humanware: Older than dirt
--------------------
old, slow, and confused
but at least I'm inconsistent!
Rich
but - the program works - just slow. ON this client, it ain't working at all!
Okay, with 2,500 rows and 62 columns - it took 15 min. 58 sec. But of that time 1 min. 28 sec. was spent on the formatting at the end. (again OS X 10.3.4 and Excel 2004.)
I'm beginning to think that if there is any attempt to switch programs - of any kind, even back and forth between Word and Excel it starts to slow down.
With the client's computer, does the program freeze? Are they able to follow the percent window?
Are they going to upgrade from Excel v.X to Excel 2004? That might make a difference.
Sorry, I'm not more help on this.
Software: LibreOffice 3.3 on Mac OS X 10.6.5
(retired Excel 2003 user, 3.28.2008 )
Humanware: Older than dirt
--------------------
old, slow, and confused
but at least I'm inconsistent!
Rich
don't know. problem - my contact with the client having the problem is 3rd person.. *sigh* but - I'll take your latest resutls and run for now.
hey - didn't you say that you read something about conflicts? cross-app?
One possibility here about conflicts:
Did they have a Test Drive version of Excel v.X on the machine, and then just installed the registered version, without uninstalling the Test Drive version? In some cases that can cause problems.
Special Bulletin: Before you install Microsoft Office v. X or the standalone versions (Microsoft Word X, Entourage X, Excel X, and PowerPoint X), you must first remove the Office v. X Test Drive from your computer. Please see Remove the Office v. X Test Drive before installing Office v. X or standalone versions of Word X, Entourage X, Excel X, and PowerPoint X.
http://www.microsoft.com/mac/support.aspx?pid=bulletin
Software: LibreOffice 3.3 on Mac OS X 10.6.5
(retired Excel 2003 user, 3.28.2008 )
Humanware: Older than dirt
--------------------
old, slow, and confused
but at least I'm inconsistent!
Rich
Here is a page that has some references for VBA programming in Excel v. X.
http://support.microsoft.com/default...b;en-us;310330
Also, I happened to notice a reference to MsgBox differences (basically the Help button does not show up in Excel v. X, but will in 97 and 2000). I wonder if there might be something connected with the MsgBox that is used that is causing a conflict.
Software: LibreOffice 3.3 on Mac OS X 10.6.5
(retired Excel 2003 user, 3.28.2008 )
Humanware: Older than dirt
--------------------
old, slow, and confused
but at least I'm inconsistent!
Rich
This may be it?
http://www.microsoft.com/mac/resourc...mats_Excel.xmlRunning Macros
Macros that make calls to custom 16-bit DLLs The DLL source code must be recompiled into a PowerPC version before the macros will run in Excel X.
Software: LibreOffice 3.3 on Mac OS X 10.6.5
(retired Excel 2003 user, 3.28.2008 )
Humanware: Older than dirt
--------------------
old, slow, and confused
but at least I'm inconsistent!
Rich