×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Design Table OLE Problem

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

RE: Design Table OLE Problem

You may be reaching the limits of the Excel OLE.  This has been discussed in Thread559-19802.

RE: Design Table OLE Problem

(OP)
Stoker,
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

(OP)
Scott,

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

My bad! I was thinking about you viewing a table in drawing and not a DT....this is what I get for being out of the loop for a while.

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

(OP)
In a seperate window, otherwise its a pain to create the DT.

Kim

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources