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?
"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).
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.
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?
The OLE error appears when the response does not arrive within the specific time period. And there three main reasons behind getting the Excel OLE action error:
So check the given reasons one by one and try to fix them. Delete the add-ins this is responsible for various issues and errors in Excel.
Hope doing this will help you to fix Microsoft Excel is waiting for another application to complete an OLE action error
Source: repairmsexcel.com/blog/resolve-excel-ole-action-error
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!