09-12-2017 06:03 PM
I am brand new to SAS, and I cannot open a file in Excel. It continously comes up with an error that Excel is waiting for another application to complete an OLE action.
What can I do to make these file open correctly?
09-12-2017 06:13 PM
"Open" or "read" or import or ??? describe how your are "opening" the file. Post code if you have it.
It sounds like something else may be touching the file. I have had occasions where an Excel file is treated as open when Excel isn't actually running. Something in the OS will say "the file is in use" when attempting to rename or delete for example. Note this is from the OS actions, not SAS.
Some guesses at causes: The file isn't actually an Excel file (xlsx) but is actually CSV, html or xml with a file extension of xlsx to "trick" Excel into opening the files. If the file in on a network or shared drive another user is doing something to the file. You are using SAS in a server mode and the Server can't actually see the file as it is on your local harddrive (though I would expect different error messages).
09-12-2017 06:23 PM
The file cannot be open when attempting this. To determine what has a lock on the file, download Process Explorer from sysinternals. it is free. Open it, find, enter the file name. it will tell you what has a lock on it.
09-12-2017 06:26 PM
Does it not work for all tables or a specific one?
Can you connect to the data via SAS directly (EG, Studio or Base) or are you working with the SAS Add In for Microsoft Office?