DT Excel Version Error
DT Excel Version Error
(OP)
I hope someone knows how to solve this. I have a part created recently and natively in SWX2010 SP2.1 using a Design Table. I have MS Office 2007 on my computer. I have been in and out of the DT several times today using both Edit Table (the Excel DT opens in the SWX file) and the Edit Table in New Window (the DT is in a stand-alone Excel session). SWX crashed on me a little while ago on this file. Restarting SWX and reopening the file shows no obvious problems. The file itself opens fine and all the configs are accurate. I can even add new configs that are not part of the DT.
The problem is when I go to edit the DT using either of the options I get the following error: "Design table was created in Excel 2002 and cannot be opened in Excel 2007." There is no option except to press the good ol' "OKAY" button. I have made a copy of this file with the same results. I have also rebooted my machine with the same results.
Please do not suggest deleting the DT. This DT is not simply holding differing values and suppression states, it is a parametric gear file with all the calculations to yield a true involute for all the different gears in it.
I have encountered this error before, but do not remember how it was resolved. I am hoping someone has a good fix.
Thanks in advance,
- - -Updraft
P.S. I also tried the "Save Table" option. Everything looks like it is saving the table, but there is no file created. I am having no other issues with SWX.
The problem is when I go to edit the DT using either of the options I get the following error: "Design table was created in Excel 2002 and cannot be opened in Excel 2007." There is no option except to press the good ol' "OKAY" button. I have made a copy of this file with the same results. I have also rebooted my machine with the same results.
Please do not suggest deleting the DT. This DT is not simply holding differing values and suppression states, it is a parametric gear file with all the calculations to yield a true involute for all the different gears in it.
I have encountered this error before, but do not remember how it was resolved. I am hoping someone has a good fix.
Thanks in advance,
- - -Updraft
P.S. I also tried the "Save Table" option. Everything looks like it is saving the table, but there is no file created. I am having no other issues with SWX.






RE: DT Excel Version Error
Joe Hasik,
CSWP/SMTL/MTLS
SW 09 x64, SP 4.1
Dell T3400
Intel Core2 Quad
Q6700 2.66 GHz
3.93 GB RAM
NVIDIA Quadro FX 4600
RE: DT Excel Version Error
RE: DT Excel Version Error
I have sent this file to my work computer and get the same results - no joy.
Joe, I did just send this off to my VAR. I was hoping someone here had experience solving this kind of problem.
- - -Updraft
RE: DT Excel Version Error
--MechEng2005
RE: DT Excel Version Error
Rob Stupplebeen
RE: DT Excel Version Error
Have you tried MechEng2005's suggestion?
RE: DT Excel Version Error
I have sent the file to my VAR and will let everyone know what comes of it.
In the meantime I recreated the file. It is a metric gear so I took my still-working parametric inch gear file and changed the Excel calcs from being driven by the Diametral Pitch to being driven by the Module. All-in-all it wasn't too bad to redo, but I don't like having such catastrophic issues.
- - -Updraft
RE: DT Excel Version Error