SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Unable to open; waiting on OLE action

Reply
New Contributor
Posts: 2

Unable to open; waiting on OLE action

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?

Super User
Posts: 10,890

Re: Unable to open; waiting on OLE action

"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).

Frequent Contributor
Posts: 88

Re: Unable to open; waiting on OLE action

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.

Super User
Posts: 18,603

Re: Unable to open; waiting on OLE action

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?

New Contributor
Posts: 2

Re: Unable to open; waiting on OLE action

So far, this is the only table it hasn't worked on. I am using a SAS add in for Office.
Ask a Question
Discussion stats
  • 4 replies
  • 106 views
  • 0 likes
  • 4 in conversation