Design Table OLE Problem
Design Table OLE Problem
(OP)
I am working on a design table with 150+ columns and 550 rows, and I keep getting this error MICROSOFT EXCEL IS WAITING FOR ANOTHER APPLICATION TO COMPLETE AN OLE ACTION. I accept the error, then excel waits about a minute, then gives me the same error, this happens about seven times, then it finally closes the design table. If I switch to Solidworks it is not waiting for a response there is nothing else going on there. Its just this process that I have to go through evertime I open the design table. If I make any changes to the design table they are showing up in the model.
Please Help,
Kim
Please Help,
Kim






RE: Design Table OLE Problem
RE: Design Table OLE Problem
Thank you for your suggestion, I am aware of the limit for columns in excel, I only have 150 columns, excels limit is 255.
Kim
RE: Design Table OLE Problem
Regards,
Scott Baugh, CSWP

credence69@REMOVEhotmail.com
http://www.3dmca.com
http://home.insightbb.com/~scott.baugh/
*When in doubt always check the help*
RE: Design Table OLE Problem
Can you elaborate on that? How is that relevant to a design table that creates configurations of parts?
Thanks
Kim
RE: Design Table OLE Problem
The Error your getting is because Windows hasn't closed it yet...if you continue to click the OK button it will eventaully close Excel....this still an MS issue and there isn't much of a fix for it that I'm aware of.
Plus with 550 rows and 150+ columns (I assume they are all active)....that is a LOT of data that SW has to process. That equals about 82,500 cells that SW has to write data in the model. I can see where this can be a bottle neck for you. Windows is probably trying to close Excel like you told it to, but since you have so much data go in to the model. SW stops Excel from closing till all data can be transferred to SW.
Have you ever got the error on your email. When your trying to access it and it keeps looking for it and then it asks you if you want to "Wait" or do you want it to "Stop"?
This error is the same thing....I hope you followed all of that.
How do you open the DT....in a separate window or within SW?
Sorry for the confusion,
Scott Baugh, CSWP

credence69@REMOVEhotmail.com
http://www.3dmca.com
http://home.insightbb.com/~scott.baugh/
*When in doubt always check the help*
RE: Design Table OLE Problem
Kim