AnsweredAssumed Answered

When adding a Excel BOM to drawing getting: "close method of workbook class failed"

Question asked by Jeroen Knuvelder on Apr 23, 2020
Latest reply on Apr 30, 2020 by Jeroen Knuvelder

Like • Show 1 Like1
Comment • 3

Since about a week ago I'm getting a "close method of workbook class failed" when adding a Excel based BOM to my drawings. Excel does seem to load, but when trying to add it to SolidWorks it refuses to work.

Because of this error I can't save my drawings afterwards, and I have to force quite it through task manager.

Also after this error SolidWorks doesn't close properly anymore, it will keep running in the background.

I thought it might be related to a windows update and tried to fix it with: VBA Solutions , but that did not seem to fix the issue.

Does anyone have a similar problem or know a fix for it?

Edit (24-04-2020): I'm almost certain this is caused by windows update "KB4549951", my colleagues now expreience this same issue. We unfortunately depend on Excel BOM's.

Jeroen Knuvelder Apr 30, 2020 5:28 AM

Correct Answer

We got a response from our reseller that SolidWorks should be working on a fix for this issue.
The issue has occurred since the 16.0.12624.20382 update.
For the time being they send us a temporary fix to downgrade Office to 16.0.12130.20344.

- Within Excel (or any other office program) under account disable updates.

- Open CMD in administrator mode

- Type: "cd %programfiles%\Common Files\Microsoft Shared\ClickToRun" Enter

- Type: "officec2rclient.exe /update user updatetoversion=16.0.12130.20344" Enter

- Optional: restart the computer

See the reply in context

1 person had this question

Outcomes

Peter Brinkhuis Apr 24, 2020 8:38 AM

It might be related to this design table issue. It goes wrong when closing the design table:

Design Table Crash

I'm glad you found a hint in the Windows update, maybe that helps the developers debug the issue.

I found that closing Excel while holding shift works about 90% of the time. But if you don't open or close the table, that isn't of much help.

By the way, there's a surprising number of Dutch people that are having these problems, it seems.

Edit: Uninstalling the update did not fix my design table issues

Actions

Howard Roepnack Apr 29, 2020 4:52 PM

I have the same exact problem. Thought it was an Excel problem so I called the Excel vendor. Did a driver update on my computer, no change. We removed 64-bit Excel and installed 32-bit Excel. Fresh installation of Excel changed nothing. Excel vendor told me to contact the SW reseller. excel based bom

Actions

Jeroen Knuvelder Apr 30, 2020 5:28 AM

- Within Excel (or any other office program) under account disable updates.

- Open CMD in administrator mode

- Type: "cd %programfiles%\Common Files\Microsoft Shared\ClickToRun" Enter

- Type: "officec2rclient.exe /update user updatetoversion=16.0.12130.20344" Enter

- Optional: restart the computer

Actions

3 Replies

Peter Brinkhuis Apr 24, 2020 8:38 AM
Mark Correct
Correct Answer
It might be related to this design table issue. It goes wrong when closing the design table:
Design Table Crash

I'm glad you found a hint in the Windows update, maybe that helps the developers debug the issue.

I found that closing Excel while holding shift works about 90% of the time. But if you don't open or close the table, that isn't of much help.

By the way, there's a surprising number of Dutch people that are having these problems, it seems.

Edit: Uninstalling the update did not fix my design table issues
Like • Show 2 Likes2
Actions
Howard Roepnack Apr 29, 2020 4:52 PM
Mark Correct
Correct Answer
I have the same exact problem. Thought it was an Excel problem so I called the Excel vendor. Did a driver update on my computer, no change. We removed 64-bit Excel and installed 32-bit Excel. Fresh installation of Excel changed nothing. Excel vendor told me to contact the SW reseller. excel based bom
Like • Show 1 Like1
Actions
Jeroen Knuvelder Apr 30, 2020 5:28 AM
Unmark Correct
Correct Answer
We got a response from our reseller that SolidWorks should be working on a fix for this issue.
The issue has occurred since the 16.0.12624.20382 update.
For the time being they send us a temporary fix to downgrade Office to 16.0.12130.20344.

- Within Excel (or any other office program) under account disable updates.
- Open CMD in administrator mode
- Type: "cd %programfiles%\Common Files\Microsoft Shared\ClickToRun" Enter
- Type: "officec2rclient.exe /update user updatetoversion=16.0.12130.20344" Enter
- Optional: restart the computer
Like • Show 1 Like1
Actions

When adding a Excel BOM to drawing getting: "close method of workbook class failed"

Outcomes

Related Content

Recommended Content

Incoming Links