On 2 prior occasions different VAR’s gave up helping me with the “Insufficient Memory to Perform Operation” error and even acknowledged that it was a long known issue with Solidworks. So, I came up with a solution without VAR help that (so far) seems to work every time.
After a several year absence I started getting this error message again. I’m posting my solution now so that Google might have time to index it before this forum changes formats.
- Make sure Excel is not open in any windows
- Save the Design Table locally to filename.xlsx
- In Excel, open the .xlsx file and Save As .xls
- Repeatedly open the .xls file and exit/save until there are no more Excel conversion messages
- Delete the Design Table
- Insert a new Design Table using the newly created .xls file
- Delete the newly created .xls Design Table
- Insert a new Design Table again but this time use the originally saved .xlsx file
I haven’t tried this with other combinations of .xls vs .xlsx but found that just deleting the Design Table and reinserting the same .xlsx file didn’t fix the problem. If you have other Design Table issues, this method might be something to try for that also.