4

I am working with a user that has Office 2007 installed. When they open Excel with a blank workbook and then try to close Excel without having done anything, it hangs for about a minute or two and then gives the warning message:

"Microsoft Office Excel is waiting on another application to complete an OLE action."

Has anyone ever seen this happen before?

It doesn't matter what Excel file they open or if it is a blank/new workbook.

3

Excel Addins

I'd guess there's an add-in doing something. With a workbook open, press Alt+t+i (or Excel Options - Add-Ins - Manage Excel Add-ins - Go). Make a note of which Add-ins are checked. Uncheck them all and see if the problem persists. If not, add them back one-by-one (fun, I know).

COM Addins

COM Addins are little harder to find, but can still cause problems. In Excel 2007, Excel Options - Add-Ins - Manage COM Add-ins - Go (In Excel 2003 or earlier, right click on any toolbar and choose Customize. On the Commands tab, go to the Tools category and find the COM Add-Ins control. Drag it to any toolbar and close the Customer box. Now click that button to see all of the COM Add-ins.) Do the same thing with COM Addins that you did with Excel Addins, i.e. uncheck them all and add back on at a time.

2
  • I tried this and there are no add-ins enabled. Any other suggestions? Thanks – Chris May 10 '10 at 22:39
  • I forgot to mention COM Addins, so I edited the answer. I think the Adobe PDF addin caused problems in earlier versions and that's a COM addin. – dkusleika May 12 '10 at 13:05
1

I want to add from my experience on office 2016, excel process used to hang on each exit for about a minute after the window closed.

The problem was a corrupt toolbar settings file : %appdata%\microsoft\Excel\Excel15.xlb

(C:\Users[your user name]\AppData\Roaming\Microsoft\Excel\Excel15.xlb)

It was 16MB in size and growing instead of being ~100k.

Solution was to close excel, rename the file to Excel15.xlb.old and re-open excel.

For more info see https://www.asap-utilities.com/faq-questions-answers-detail.php?m=286

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.