Date:         Tue, 13 Feb 2007 11:57:23 +1100
Reply-To:     "Johnson, David" <David.Johnson@CBA.COM.AU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Johnson, David" <David.Johnson@CBA.COM.AU>
Subject:      DDE file open is very slow
Content-Type: text/plain; charset="us-ascii"

After running batch jobs for more than six months which opened, created,
updated and saved Excel files with DDE, I have never seen this issue
before.


A batch run last night, the first time on this Windows desktop machine,
started Excel, saved some data and closed the Excel file.

Unfortunately, the Excel start-up took 5hrs 38 minutes, which was the
time between the SAS code file starting and my unlocking the screen
saver.


On opening the desktop, there were no dialog boxes seen except for the
SAS batch windows and process crawlers.


Excel is started minimised, and I didn't see anything untoward from that
application.


There is only one Excel instance, so it isn't a personal.xls conflict.


The default book on opening is book1, and this doesn't exist.


The data disk is local, so it isn't prima facie a transient network
issue at 5am today.


The startup command and data step has been run repeatedly over the last
few weeks in an interactive session, and usually Excel startup is
virtually immediate.


The screensaver was operational, but I was still logged in.


Has anyone else had this problem and perhaps noticed any other symptoms?


I shall run some Mickey Mouse batches today and try to replicate the
problem, but I don't hold out any great hope.  Any other experiences
should help narrow the suspects.

Kind regards

David

************** IMPORTANT MESSAGE *****************************
This e-mail message is intended only for the addressee(s) and contains information which may be
confidential.
If you are not the intended recipient please advise the sender by return email, do not use or
disclose the contents, and delete the message and any attachments from your system. Unless
specifically indicated, this email does not constitute formal advice or commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries.
We can be contacted through our web site: commbank.com.au.
If you no longer wish to receive commercial electronic messages from us, please reply to this
e-mail by typing Unsubscribe in the subject line.
**************************************************************