Mauricio Martinez-Saez

"Microsoft Office Excel is waiting for another application to complete an OLE action" Alert when updating Design Tables

Discussion created by Mauricio Martinez-Saez on Feb 3, 2007
Some of you get a "Microsoft Office Excel is waiting foranother application to complete an OLE action" when updating adesign table (after closing the table) on a large assembly whichtake a long time to rebuild?

The solution is very simple.... just add the following macro to thedesign table (add it as an autoexecute on start macro so it runs asthe table open)>>>

' Macro to supress Waiting Alerts
--------------------------------------------
Sub nomorewait()
      Application.DisplayAlerts =False
End Sub

Happy

Outcomes