Skip navigation

24 Replies Latest reply on Mar 6, 2017 11:04 AM by Junko Fujiwara

Design table cannot be opened in Excel

Ziggi Zag Nov 8, 2011 3:51 AM

Well,

I know this error is a known bug but it seems it has come back:

Design table was created in Excel 2007 and cannot be opened in Excel 2007

I use SW2011 x64 SP5 on Windows 7 x64.

Simply - no way to use design tables due to this issue !!!

Any idea how to overcome?

Rgs,

Re: Design table cannot be opened in Excel

Markku Lehtola Nov 8, 2011 4:57 AM (in response to Ziggi Zag)

Try "File-Reload", works for me.

br
Markku
ww.sloworks.fi
Like Show 1 Likes(1)

Actions
- Re: Design table cannot be opened in Excel
  
  Ziggi Zag Nov 8, 2011 5:45 AM (in response to Markku Lehtola)
  
  Does not for me - the design table Excel file is actually corrupted - it does not open in Excel at all even while opened with Excel separately of Solidworks.
  
  This is really very unstable - sometimes, very rarely I can create a working design table but it sooner or later is getting corrupted and does not open any more.
  
  Like Show 1 Likes(1)
  
  Actions
Re: Design table cannot be opened in Excel

Sander Buys Nov 8, 2011 5:29 AM (in response to Ziggi Zag)

Are you using Enterprise PDM ? If so, you might have to check in the part prior to creating the design table...
Like Show 1 Likes(1)

Actions
- Re: Design table cannot be opened in Excel
  
  Ziggi Zag Nov 8, 2011 5:45 AM (in response to Sander Buys)
  
  >> Are you using Enterprise PDM?
  
  Nope.
  
  Like Show 1 Likes(1)
  
  Actions
Re: Design table cannot be opened in Excel

Sander Buys Nov 8, 2011 5:56 AM (in response to Ziggi Zag)

As you mentioned yourself there are a lot of possible causes for this issue and there are also some reports of bugs resulting in the same error. I once had it resolved by disabling the "send to bluetooth" add-in in excel. Maybe you wanna check this in excel...
Like Show 1 Likes(1)

Actions
- Re: Design table cannot be opened in Excel
  
  Ziggi Zag Nov 8, 2011 6:15 AM (in response to Sander Buys)
  
  Sorry - I have no such an add-in in Excel (send to bluetooth) :-(
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Design table cannot be opened in Excel
    
    Scott McFadden Feb 8, 2012 6:40 AM (in response to Ziggi Zag)
    
    Ziggi,
    For me usually what Markku suggested as worked. The other thing I have tried and have
    had success with is the office diagnostic tool. Try running that and see if it fixes your issue.
    
    Like Show 1 Likes(1)
    
    Actions
    - Re: Design table cannot be opened in Excel
      
      Ziggi Zag Feb 8, 2012 4:09 PM (in response to Scott McFadden)
      
      Nope, MS Office is flawless. Obviously, the flaw is in the way SW uses Excel com server.
      
      Like Show 1 Likes(1)
      
      Actions
      - Re: Design table cannot be opened in Excel
        
        Bartosz Stefaniak Feb 8, 2012 4:19 PM (in response to Ziggi Zag)
        
        i have the same feeling. i've reinstalled SW without any result. W 7 - (64 bit) Office 2007 (32 bit) SW 2011 sp5.0 (64 bit)
        
        Like Show 1 Likes(1)
        
        Actions
        
        Re: Design table cannot be opened in Excel
        
        Ziggi Zag Feb 8, 2012 5:23 PM (in response to Bartosz Stefaniak)
        
        Hehe - same setup like mine :-)
        
        It seem the right solution is switching to Office 2010 x64.
        
        Not confirmed but I heard that from trusted source.
        
        Rgs,
        
        Like Show 1 Likes(1)
        
        Actions
        
        Re: Design table cannot be opened in Excel
        
        Bartosz Stefaniak Feb 17, 2012 3:27 AM (in response to Ziggi Zag)
        
        bad news...
        Office 2010 didn't help me.
        
        and than
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: Design table cannot be opened in Excel
        
        Thomas S. Feb 17, 2012 4:36 AM (in response to Bartosz Stefaniak)
        
        Had recently same typ of problem with a big design table (SW2011SP5 XPx86 but no help opening in W7x64). Sent it to SW but they could not restore it in any way...
        
        Like Show 1 Likes(1)
        
        Actions
        
        Re: Design table cannot be opened in Excel
        
        Peter Andersin Mar 6, 2012 9:08 AM (in response to Bartosz Stefaniak)
        
        You need to disable the bluetooth thingie from excels add-ins.
        
        -Peter
        
        Like Show 1 Likes(1)
        
        Actions
        
        Re: Design table cannot be opened in Excel
        
        Ziggi Zag Mar 6, 2012 1:30 PM (in response to Peter Andersin)
        
        >> You need to disable the bluetooth thingie from excels add-ins.
        
        Why the hell there are so many morons believing we all have some "bluetooth thingie" in between Excel add-ins?
        
        Like Show 1 Likes(1)
        
        Actions
Re: Design table cannot be opened in Excel

Bartosz Stefaniak Feb 8, 2012 5:10 AM (in response to Ziggi Zag)

Any ideas if it will also happend in SW 2012 ?
Like Show 1 Likes(1)

Actions
Re: Design table cannot be opened in Excel

Roel Kersten Mar 1, 2012 5:07 AM (in response to Ziggi Zag)

I had the same problem when i first used design tables. (SW2011, Office 2010)
The thing that seems to work for me is creating a seperate excel file, linking to that file and check the box "block model edits to update the design table".
when editing the table, edit it in a seperate window, not within solidworks.
hope this is of any use to you.
Like Show 1 Likes(1)

Actions
- Re: Design table cannot be opened in Excel
  
  Daniel Schulz Apr 17, 2012 11:33 AM (in response to Roel Kersten)
  
  I find editing in seperate window actually makes things worse. We use a ton of very large design tables here, and the OPs error sometimes crops up. As other have suggested, re-loads, re-boots, and excel repairs ocasionally help. Unfortunately, sometimes the only fix is to delete the design table, and recreate it. I use auto-create, but it's still usually a lot of work. This issue has been around for several releases.
  
  Like Show 1 Likes(1)
  
  Actions
Re: Design table cannot be opened in Excel

Kiran P Mar 22, 2013 5:04 AM (in response to Ziggi Zag)

I have the same problem.I found another way of making it work.
After closing the message box, right click and click on 'save the design table'.You don't need to save the file.
Now the design table is open inside solidworks and can be edited.Although, you cannot edit it in a new window.
Like Show 1 Likes(1)

Actions
Re: Design table cannot be opened in Excel

Tom Bostick Mar 22, 2013 9:50 AM (in response to Ziggi Zag)

I normally just close Excel and then open the design table again.
Like Show 1 Likes(1)

Actions
Re: Design table cannot be opened in Excel

Kiran P Apr 11, 2013 5:20 AM (in response to Ziggi Zag)

If you have inserted images in your DT, then after a while it cannot be opened in a new window.
I removed the images in my DT and it works fine.
Like Show 1 Likes(1)

Actions
Re: Design table cannot be opened in Excel

Rod Hayes Aug 27, 2013 12:17 PM (in response to Ziggi Zag)

I solved my problem by right clicking on design table, click on "Save Table...", it then seemed to update the table. I then closed without saving and it reopened ok. Hope this works for you.
Like Show 1 Likes(1)

Actions
Re: Design table cannot be opened in Excel

Junko Fujiwara Mar 6, 2017 10:39 AM (in response to Ziggi Zag)

I have the same problem with SW 2017 SP2 running on Windows 7 x64. Microsoft Office Excel 2007

When I tried open the Design Table, I get this error.

Hit "OK" then I get this error.

I've tried "Save Table", but no files was saved.
Microsoft Office Diagnostics found no issues.
I send the file to my software vendors and hope they will recover the data...
But I am feeling that I will have to recreate this part file again...
Like Show 1 Likes(1)

Actions
- Re: Design table cannot be opened in Excel
  
  Craig Schultz Mar 6, 2017 10:48 AM (in response to Junko Fujiwara)
  
  This might be the issue.
  
  Like Show 1 Likes(1)
  
  Actions
  - Re: Design table cannot be opened in Excel
    
    Junko Fujiwara Mar 6, 2017 11:04 AM (in response to Craig Schultz)
    
    Craig,
    
    Thanks for your reply. That might be the cause of the issue.
    Boy, I did not know Excel 2007 is End of Life for SW2014.
    
    Like Show 0 Likes(0)
    
    Actions

Go to original post

More Like This