This has happened to me a few times before, OK SW has bugs but this is a real pain. I have a file with about 100 configs in it. If worked fine the day before but some where along the way it decided to give me an error when I try to open it. I've tried it on a machine with excel 2000 and another machine with 2003. Both give the same error. "Unable to open design table using Excel 200X" In the past my VAR actually said to recreate the file. Has anyone else had this?
Tried to save the excel file and it only wants to save it as xlsx? Since I do not have 2007 at the office I'm not sure what's up yet. Wen I do tell it to save it looks like it does but no file is created. I'm going to talk it home tonight and see what I can do there.
By the way it's 2009 4.1
Attachments
Opens fine in Excell 2k7, like stated above it is probably in *.xlsx format. I saved it in *.xls (>=2k3) format.
You can delete the existing table and insert this one. I like the "VAR says to recreate the file..." those folks are allways fun....
Attachments
You can also use this Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats.
Brief Description
Deepak , I dont understand when to use this patch you have linked. I have office 2007 and my files have an extra x (.xlsx). I have the same issue with the DT. Solidworks errors out "Unable to open DT using Excel 2007"
Should I install that patch?
This patch is to open Excel 2007 files in 2003 version.
Fixed in:
SPR 530554
SPR #:
504411
SPR #:
558383
SPR #:
492170
SPR #:
539189
SPR #:
558790
SPR #:
557905
SPR #:
513625
SPR #:
538367
SPR #:
471935
SPR #:
559341
SPR #:
510717
SPR #:
558891
SPR #:
528511
Solution Id:
S-039301
Solution Id:
S-025688
Solution Id:
S-047741
Solution Id:
S-030582
and the winner is...
SPR #:
518650
Product:
SolidWorks
Status:
Under review (Corrupt file)
Fixed in:
2009 SP05
Area:
Assemblies
Sub-Area:
Design Table
Customer Impact:
Critical
Summary:
Corruption: error while trying to edit design table "Unable to open design table using Excel 2007/2003"
Technical
Comments:
SPR 518650, was marked as REPAIRED in 2009 SP05 and was marked as REPAIRED in 2010 SP02 and was marked as REPAIRED in 2010 SP02.1 and was marked as REPAIRED in 2010 SP03 and was marked as REPAIRED in 2011 a1
I'm in discussions with my own VAR with respect to this issue. 2010 SP3.0 on XP64 and I'm still encountering this one at least 3-4 times a day. I've been part of several other posts on the issue and have tried all the suggested actions (MS Office diagnostics tools / re-installing) all to no avail.
Files sent through to VAR have come back clean and they are unable to reproduce the issue I'm facing on their machines. Having to reboot the machine so many times is a real hit on productivity and not helping my caffeine addiction.
Has anyone else out in the abyss found a resolution they'd like to share ?
I am using Solidworks 2010[64 bit] with MS Office 2007 and had this same issue.
"Unable to open design tables using excel 2007" I believe i have solved this issue.
My fix:
Go to your 'C' drive and drill down to the microsoft office folder with your excel shortcut.
Mine is located here; C:/prog files[x86] / microsoft office/office12
Right mouse click on the excel application icon and click properties.
Uncheck the read only box and click apply.
Do the same thing for the excel MS Office shortcut and click apply
This solved my "Unable to open design tables using excel 2007" issues.
Hope this helps.
Rik Stewart
Crown Solutions
Dayton, Ohio
For what it's worth...
I'm running SolidWorks 2009, SP04 and Office 2007... Upgraded from Office 2003 since last successfully editing a Design Table more than once in the same session.
Started getting the infamous "Unable to (do something very basic)..." message on the 2nd edit of a Design Table this morning. Researched the forums and found a lot of info, but no solid fix.
I looked into unchecking the Read Only property on EXCEL.EXE as mentioned above, however mine was already unchecked.
Someone mentioned saving the table and reinserting. That fixed it for me - I can now edit the design table over and over and all is well.
Unfortunately this doesn't help those folks with hundreds of parts with Design Tables. Perhaps a macro to open, edit, save DT, then delete and reinsert is in order - with a follow on activity to do this recursively to a bunch of files within a folder, or based on a list?
I wonder what the root cause of this issue is, and why it continues to cause problems years after being found, reported and solved.
... tho - all that being said... I moved on to a 2nd part of the same vintage with a Design Table - fully expecting to have to save/reinsert its Design Table - and it worked perfectly fine without having to do that...
Go figure...
... then later in the day - the issue reappeared in the original file that I fixed, and edited the table in repeatedly probably 20-30 times. Ugh this one sucks!
By chance do you already have excel open and editing a cell in a diferent file prior to trying to edit your design table? This will cause this error to occur.
In some cases yes, but in other cases no.
I will pay attention to this today as I deal with this issue while trying to get some real work done lol.
Today I am unable to duplicate the problem, whether or not I already have Excel open and with or without another workbook open and/or editing a cell.
I tried every scenario to get it to belly up, and it wouldn't. This is not a bad thing, however it doesn't help to understand the problem (but I'll take it).