×
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

HELP...!!! Excel busy can't edit BOM....

HELP...!!! Excel busy can't edit BOM....

HELP...!!! Excel busy can't edit BOM....

(OP)
Anyone know what this problem is all about..the subject
line pretty much sums it up...any tips appreciated...

Dave

RE: HELP...!!! Excel busy can't edit BOM....

While I havent seen this message yet in regards to design tables, a message like this from an OLE operation can mean that the server application is in need of user interaction.

This could be something like a dialog box is popped up in the application, or a worksheet is re-calculating, or ...??



RE: HELP...!!! Excel busy can't edit BOM....

dutch7777,
Yes, I have gotten this message several times. When I have Excel open, my Excel BOM cannot be inserted. Once I close Excel then SolidWorks allows inserting my BOM.

Bradley

RE: HELP...!!! Excel busy can't edit BOM....

I've also had frozen Excel. It was allways related to the need of rebuilding the SW part/assembly or to the need of closing some information window popped by SW.

Regards

RE: HELP...!!! Excel busy can't edit BOM....

Is this because of the security level on Excel? It may be waiting for permission to run macros.

Crashj 'please do' Johnson []

RE: HELP...!!! Excel busy can't edit BOM....

If you have Excel open and have the curser in a cell and switch to SolidWorks you will have problems. It seems if you have several Excel files open even without the curser in a cell there can be stability problems. Some time you can have more than one Excel running, then use the task manager to kill one or both, then restart Excel with no files or work sheets open.

RE: HELP...!!! Excel busy can't edit BOM....

(OP)
Well, thanks to all for the help but no one really hit the nail on the head...Here's what I'm experiencing..........
A parts explosion drawing with one view only and a excel
bom...data on server, excel local....no other apps open...edit the bom, can sort ok but if I try to resequence the item no's it kicks a message "other program busy....
excel...??? dunno, but it starts the start menu....now get
this...if I pull the bom off the sheet/view (1) completely
it'll work just fine...now the kicker...it works on some
drw's and not others...at least I got it to work tho..

Thanks again to all for the tips...gremlins....arrrrgh

RE: HELP...!!! Excel busy can't edit BOM....

I have had some problems with Excel, and thought my prior post solved them. In the last 3 days BOM’s have caused sever crashing of Excel and SolidWorks. The tool bars disappear and even after closing SolidWorks, I must kill it in the task manager. I’ve rebooted thinking it would help, but no change. I’ve only had the server busy window once out of about 10 crashes.
I think some of it is from trying to edit the BOM from older formats. The only solution so far is to delete the old BOM and start the BOM process over.
The other possibility is some new Windows update is causing the problem. I didn’t seem to have as many problems until after the last security updates from Microsoft.

RE: HELP...!!! Excel busy can't edit BOM....

I use Design tables in every (thousands) of Solid Works file we have.  One trick that may be useful is to open Excel first thing in the morning before you do anything.  Excel tends to hang sometimes, if it does hang re-boot and try again.  Once you are getting a good start up with Excel, then proceed and open Solid Works and you should have less trouble.  One last tip, disable any Add-ins that in Excel that you dont need.  Hope this helps, someone.

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