I don't know why i get this error each time i try to edit the design table
"design table was created in excel 2007 and can't be opened in excel 2007"
Hi this has been a known bug as found by Bernie Andreoli here Re: Cannot open Design Table
Try repairing your MS office installation as suggested by Wayne Tiffany here Re: excel file problem
Try Rik Stewart's method as suggested here Re: Design table issue - Unable to open DT using Excel 2XXX
Deepak thank you very much for suggestions, but they din't work with me
i tried every possible way no thing worked
i also re-install MS 2007 but no result
i install MS 2010 but no result
i asked all my friends for MS 2003 and it really works
I have had this come up and all i do is to do a reload in the part and then open the design table
Check out this thread as well.
I was getting this error in 2007 and in Excel 2010. Here's what I did to fix it. Go to File, Options, Trust Center, Click on the Trust Center Settings Button, File Block Settings, uncheck the boxes beside Excel 2007 and later Workbooks and Templates. This fixed it for me. For whatever reason if those boxes are checked it will give me the "Design table was created in Excel 2010 and cannot be opened with Excel 2010.
Retrieving data ...