Today I am getting a “Your system must have Microsoft Excel Version 8 or higher” error window. I can’t close it, so I am hung with lost work. It occurs with a drawing that contains a design table. No trouble with that in the past. I am running SW2022 sp5 and Office 365 (64-bit).
Weird. I’ve been hitting that “X” button in the window corner for a while now. Just now it worked. I am saved. Still, I don’t know why the error is coming up all of a sudden.
Doing a search, this problem has been around for a while. Try closing excel before opening the file again and see if the problem still exists.
“If Excel is running and there is a dialog box owned by the Excel process showing (an example would be the File → Open window or the Excel Options window) than this error message can occur. Please close other Excel dialogs before interacting with anything that would use an Excel table in SOLIDWORKS in order to resolve this issue.”
I have seen this stated several times - we also use office 365 32bit for compatibility with old software, and 32bit Office365 works fine with Solidworks (2023).
The likely actual problem is that Office needed repairing, obviously if you install 64bit the new install will also fix the problem, but we have had issues with not being able to add design tables and it was fixed with quick repair of office 32bit.
When you create a design table, it initially opens the spreadsheet inside of SW. You can do nothing with the table when it is opened that way. You have to close the spreadsheet, and then “Edit table in new window”. After that, everything works as intended.
I’m on SW2022 SP5.0 and Microsoft Office Home Business 2019 correctly installed and updated.
Still getting the error
image.png
I can’t even save the BOM as XLS or XLSX.
This is very annoying.