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?
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
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
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
Regards,
Scott Baugh, CSWP

3DVision Technologies
http://www.3dvisiontech.com
http://www.scottjbaugh.com
FAQ731-376
When in doubt, always check the help
RE: Excel crashes and Solidworks
RE: Excel crashes and Solidworks
RE: Excel crashes and Solidworks
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
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
Thanks for the help.
RE: Excel crashes and Solidworks
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
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.