Problem Exiting Design Tables in SOLIDWORKS?

Please note that this issue is not reproducible in Office 365 releases starting with Version 2004 (Build 12730.20270) released on May 12, 2020.

There is currently a compatibility issue between Microsoft Excel based Design Tables in SOLIDWORKS and some versions of Microsoft Excel. These versions include Version 2003 (Build 12624.20320), Version 2003 (Build 12624.20382), Version 2003 (Build 12624.20442), and Version 2003 (Build 12624.20466).

The compatibility issue may be triggered when editing design tables or inserting a new Microsoft Excel based design table and can result in difficulties exiting the design table.

Edit Table in New Window

A possible workaround for ‘Edit Table’ function that cannot be exited is to use the option ‘Edit Table in New Window’.

Edit Table in New Window

Rollback Microsoft Excel

Another workaround is to roll back Microsoft Excel to prior to this version (for example roll back to Version 2002 (Build 12527.20278) or older). This is specifically important for users who use Microsoft Office 365 which auto-upgrades to the latest version.

To find out Microsoft Excel version, follow the instructions below:

1. Open Microsoft Excel.
2. Navigate to File> Account.
3. The version of the installation can be viewed next to About Excel. 

Finding the Version of Microsoft Excel

Also, a list of all the Microsoft Office update history can be found on the Microsoft website.

To start rolling back the Microsoft Excel version, first make sure the automatic updates are disabled following the steps below:

1. Open Microsoft Excel.
2. Navigate to File > Account > Upgrade Options > Disable Updates. 
3. Close Microsoft Excel. 

A reminder can be set up to manually check for future versions to update Microsoft Excel when this issue is resolved.

Disabling Automatic Updates

Once the automatic updates have been disabled, in order to revert Microsoft Excel to a prior version, please follow the instructions on the Microsoft website.

A permanent solution is coming soon

SOLIDWORKS is actively working on a permanent solution for these issues. With a valid subscription contract, SOLIDWORKS users affected by Microsoft Excel-related issues may contact their Value Added Reseller to ensure they are notified when the solution has been implemented.