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)