Editing Excel BOM in separate window?

I don't think you can do this. You can edit design tables in a new window, but not BOM's.

John Layne wrote:

"John Layne"

Yes, it should be possible. One of our users had issues with this, and sometimes would get an "Interface Not Registered" error. Here is the solution from Microsoft's website:

When trying to send Email from one or more Microsoft Office product, I get the error E-mail Automation Error "Interface not registered"

CAUSE Another software installation, spyware, adware or virus caused invalid keys registrations on Windows

RESOLUTION Hit Start then Run

Register Files with RegSvr32

RegSvr32 OLE32.DLL RegSvr32 MSRDO20.DLL

Be sure that you "Cut" all invalid Registry Keys

Hopefully this works for you.

Deb

Not entirely sure how this is related to Excel "Bill of Materials" in SolidWorks?

John Layne

On Thu, 1 Jun 2006 17:22:27 +1200, "John Layne"

Your memory is not failing you - it was possible to do this a few releases ago, but I can't remeber when :-) - 2004 perhaps

In sw2006 I can't find the magic combinations of keystokes to do it anymore. SW just don't seem to be able to stop fiddling !!

I hope someone can explain how it is done now,

Jonathan

"John Layne" >

> SUMMARY

I don't know why it worked - it just did. You asked a question and I told you what worked for us. We tried everything else imaginable to fix the issue before trying this. Yes, it was SW2006 - not sure which service pack (I think it was 3.0) YMMV

Deb

Thanks for your reply Deb, it is appreciated. Could you let me know where the button is?

ie, when trying to edit an Excel BOM in Excel in a new window what button do I push. Is it on the right mouse click menu, is there a setting in options?

If it still exists in SolidWorks 2006 I can't just can't find it.

John Layne

Just to clarify I can edit the Excel BOM in Excel from within SolidWorks. I want to open the Excel BOM in a seperate Excel Window as you can with Design Table.

John Layne

"John Layne" > told you what worked for us. We tried everything else imaginable to fix

there was a general option at one time. i believe with the advent of solidworks bom in 2004, that this option was removed.

My VAR says this is not possible, he checked 2005 and 2006. One of us is insane- not quite sure who at this stage as evidence for both possibities is freely available.

John Layne