Hi,
I try to edit design table in my SOLIDWORKS 2020 SP1, and use Ms. Excel 2019, but after input the value in excel and click in graphicas area SOLIDWORKS the software automaticly hang, cannot do anything, all of command to be gray, cannot exit....
FYI, i'm already try unistall and reistall SOLIDWORKS....
in KB i'm don't found the solution, have anyone in here get same issue...
thanks you
If you are editing a design table in Excel you cannot use any SOLIDWORKS interface commands. You need to close out of Excel when you are finished to be able to use SOLIDWORKS again.
If you are not aware yet, there has been a critical bug reported with SOLIDWORKS for hanging when using design tables. This is caused by the most recent update from Microsoft Excel. Version 16.0.12624.20382 of Excel causes crashing, make sure this is not your version and if it is you will need to rollback the Microsoft update to a version before this.
PSA: Not all versions of Excel are supported by SOLIDWORKS, Office 365 with auto updates are not supported as this means the program is constantly changing and cannot be bug tested with SOLIDWORKS.
ok, i see, thank for your explanation...btw i think because i'm use Ms. Excel version 16.0.12730.20188...
Maybe for now i'm use another way with Edit Table in New Window, for editing...
Many issues with Design Tables in SolidWorks. Search in the forum on "Design Table"and you will get a lot of results, including suggested solutions/work arounds, like always "edit table in new window"
Solidworks 2020 SP2.0, Excel 2016 latest update
I don’t know why but the “Edit Table” exit hang up bug has disappeared on both the workstation and laptop. I checked to see if MS silently updated Win 10 or Office 2016 but couldn’t find anything.
Exciting news!
As previously shared earlier in this thread, Excel 16.0.12624.20382 may cause SolidWorks and MS Excel to hang when exiting a design tables or inserting Excel based BOM.
Critical SPR 1176993 was raised and SolidWorks Development collaborated with our partners at Microsoft and have resolved this with the latest Office update from the 4th of May: Version 2004 (Build 12730.20250).
SPR 1176993 & SPR 1178500 have been marked resolved and KB items S-077848 & S-077850 are currently being updated\published.
If you are experiencing a hang editing design tables or inserting Excel based BOM - Please use Windows Updates or contact your IT department to obtain Version 2004 (Build 12730.20250).
Cheers,
Mark Johnson | SOLIDWORKS Escalation Manager, Americas
Dassault Systèmes SolidWorks Corp.
Exciting news!
As previously shared earlier in this thread, Excel 16.0.12624.20382 may cause SolidWorks and MS Excel to hang when exiting a design tables or inserting Excel based BOM.
Critical SPR 1176993 was raised and SolidWorks Development collaborated with our partners at Microsoft and have resolved this with the latest Office update from the 4th of May: Version 2004 (Build 12730.20250).
SPR 1176993 & SPR 1178500 have been marked resolved and KB items S-077848 & S-077850 are currently being updated\published.
If you are experiencing a hang editing design tables or inserting Excel based BOM - Please use Windows Updates or contact your IT department to obtain Version 2004 (Build 12730.20250).
Cheers,
Mark Johnson | SOLIDWORKS Escalation Manager, Americas
Dassault Systèmes SolidWorks Corp.