×
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

Excel crashes and Solidworks

Excel crashes and Solidworks

Excel crashes and Solidworks

(OP)
I have been having a lot of trouble with both software packages.

I am running on Windows XP Professional Version 2002 Service Pack 1

SolidWorks 2003 SP3

Microsoft Excel 2002 SP-2

I don't know how to reproduce this problem, but it happens very frequently. When I start up Excel on its own it crashes. Asks me if I want to recover my work and send an error report. This happens continuously until I do on of the following:

The first one I found was to start a new SolidWorks file, insert a design table. Edit Table in New Window. Now I can open any existing Excel file. This also works by opening an existing SolidWorks file that has a design table.

The second way I found, by accident, was to open an older file, which happened to be a copy of a SolidWorks design table. After that Excel works fine.

Sometimes when working with Bills Of Material in SolidWorks drawings Excel will crash also.

Has anyone experienced anything similar? Any ideas?

RE: Excel crashes and Solidworks

If you have Excel open in SolidWorks and try to do anything in Excel on a different file both will crash. I don’t think SolidWorks shares Excel well.
The solution is to make sure you do not have Excel open in SolidWorks if you leave SolidWorks, if editing a BOM, close editing before leaving SolidWorks.
Are you trying to copy information from a file in Excel to an Excel file in SolidWorks?
Will Excel run if SolidWorks is closed?

RE: Excel crashes and Solidworks

(OP)
I'm not trying to copy anything, just work within files.
Excel won't run on its own once the crashing cycle starts, I have to go through Solidworks to get it to run.

RE: Excel crashes and Solidworks

(OP)
I've re-installed Excel 2 or 3 times now.

RE: Excel crashes and Solidworks

I was reading about crashing problems from SolidWorks, it suggested to look to see if Excel is running if you are having crashing problems. I think if you have done a task within SolidWorks that uses Excel, or have done something in Excel, you need to use Task manager to see if the task is complete before moving on. I have found if you get to far ahead if the process the machine will crash.

RE: Excel crashes and Solidworks

What version of Office or Excel are you running?

From SWX website:
Design Tables or Bills of Materials and Office 97 SR-2:
If you are using Design Tables or Bills of Materials, we strongly recommend you install Microsoft Office 97 Service Release 2 (SR-2). Installing this Microsoft Office Service Release fixes a Microsoft problem that causes either or both Excel and SolidWorks processes to remain running when you exit SolidWorks.

RE: Excel crashes and Solidworks

I disagree with EdDanzer's global comment.  It may be true in certain circumstances, but we use Excel both opened from in and out of SolidWorks and routinely open other Excel files at the same time without any problems at all. We do this repeatedly all day long and rely on it for a design automation tool I developed.  We have found the SolidWorks/Excel interaction to be extremely robust.

It definitely sounds like there is something unclean about your Excel installation.

Here's a thought.  Are you on a network?  If so do you have Excel installed locally on your system (you should) or is it by network access (bad).  Is your system trying to execute from both versions?

RE: Excel crashes and Solidworks

(OP)
We have one machine that this works just fine on as JNR says he does, there is another machine where it has been a thorn in our side.  It is installed locally, but access files over a network.  We have re-installed both programs many times with no changes.  Solidworks has been of no help as has Microsoft as has our in-house support crew.  I was just looking to see if anyone has had this problem before we rebuild the machine from scratch.

Thanks for the help.

RE: Excel crashes and Solidworks

One thing I noticed about some OLE applications (including SW), is that when the parent app has more than one version or sub-app to run when starting the application, that the registry stores the last used version. Then, on consecutive OLE/DDE calls, this version will be used.

Manually starting SW explorer, then shutting it down, then attempting to start SW from Excel can do much the same thing: instead of SW being started,  SW explorer would be.

RE: Excel crashes and Solidworks

Sorry I didn’t clarify better.
If you have the cursor in a cell of Excel either in a BOM or an Excel worksheet and try to move to the other window is where I have seen problems.

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