Design Table Issue "Excel is waiting ....OLE Action" How to Fix?

I have had to endure this problem for a few years now. I have been able to do a work around by not using a design table in these conditions.

Situation now is I am having major issues with BOM Configuration Column's Part Numbers appearing out of numerical order. I am hoping that creating a design table then rearrange will fix that issue. But this has been a 2 day event with no results.

I am getting the dreaded "Microsoft Office Excel is waiting for another application to complete an OLE action. I have checked and tried various MACRO's but nothing is working I have done a search within this forum and still nothing.

I am running Win7 64 bit x SW 2010.

Anyone with a solution? (Googling has resulted in nothing of any value and lots of guess non working ideas)

SolidworksConfigurations design Tables
Answers 9
SM
SM 2011-04-05 Best Answer

William,

See if this thread helps you.

https://forum.solidworks.com/message/7991#7991

WT
WT 2011-04-05

Tried that one and the results were not favorable. I open the assembly, run the macro, then create a design table, then i get  the Design Table "Auto Create" then select Go, Then Nothing more happens at all. Waited several Mins still nothing. Tried again to insert a design table then I get the same result. No table is created at all.

I would have to exit Solid Works and reopen the Assembly. Then I had tried the other posted possible fix https://forum.solidworks.com/message/33281#33281 and on this one funny things happens,I get some flashing, then a window XX Documents, 1 of which had design tables, Do you want to update all these tables?, I say yes then nothing else happens.

I tried once again to insert a design table, and again nothing.

I am really confused on what I can try next.

SM
SM 2011-04-05

Could there be an incompatibily issue between your copy of office and Solidworks?

EW
EW 2011-04-07

I've had the same error message appear back to at least SolidWorks 2008 during rebuiilds. Using MS Excel 2003 or 2007 didn't make a difference. Nor does it seem to matter whether I use a design table or not, but I'm not sure about that. I now have SW 2011 and Excel 2007 and it still happens. I've learned that the only way to deal with it is walk away and have a cup of coffee. Once the rebuild has completed (the rebuilds seem to continue in the background) I'm able to click on the error message and it goes away. In my case, it's an annoyance but it hasn't caused any catastrophies. Yet.

WT
WT 2011-04-08

Thanks all,

I had found out that the solution was the Macro provided from another posting did at the end work. I had tried it earlier and it would not work. It was later discovered, that excel was running in the back ground. when I found this out, I killed it from the task manager, then reran the macro, and it suddenly began working again without errors.

At least it stopped the looping problem and generated the design table.

MB
MB 2017-05-10

SW2017 SP3   Win10   Office 2016

This issue used to pop up occasionally but now is happening more often.  I have a part design table with hundreds of configurations.  When I exit the table, this message is displayed.  When I click OK or press the keyboard space bar, it goes away then reappears after 15-30 seconds.  It seems to be happening one by one for each configuration.

Solutions and suggestions in this old thread don't work or apply.

Any Ideas on how to stop this?  It's a huge productivity killer.

comment imagecomment image
JM
JM 2017-11-15

I'm having the same problem (error message) today after editing a design table.  SW appeared to lock up (spinning wheel), then the message was displayed, but I initially couldn't click OK.  I walked away, came back and can now click OK, but the message repeatedly pops-up, about 12 times so far (going to kill SW and try again).  I had only 3 or 4 configurations when I started, deleted all but 1, then tried to add one via the DT.

I'm running SW2016 SP5, Win7, Excel 2010.

JM
JM 2017-11-15

So, I re-opened the assy file, which was last saved with only 1 configuration and a design table.  I deleted the design table and tried manually adding a configuration.  This locked up SW again into a temporary spinning wheel situation, but resolved after a few minutes.  Now, every time I switch configurations, SW locks temporarily and just flashes between spinning wheel and the normal cursor for minutes each time.

CK
CK 2022-06-07

Broken link....