×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

My Excel hates my Solidworks

My Excel hates my Solidworks

My Excel hates my Solidworks

(OP)
I have two problems they both have to do with Solidworks and Excel playing nice with each other..

The first While editing deign tables I can not use the excel menu functions if I just "Edit Table" If "Edit table in new window" all works fine.  I have foun that if I Insert>Objet> Excel worksheet then save the part delete the inserted table my Excel menu bar will function fine.  I'm guessing there is a registry or library not loading proerly but I could use some help figuring it out.  

The second is in an drawing Insert>Table>Excel based Bill of materials is always greyed out.  I have reinstalled Office and soldiworks but nothing helps.  The regular BOM function works but I need to use a Excel based BOM's.  I can not find any solution or work around for this one.

Currently Running:
Soildworks 2006 SP3.0
Microsoft Office 2000 SP-3
Windows 2000 SP-4
2.6 Pentium 4 w/HT
2 Gb ram
and over 80Gb free space

RE: My Excel hates my Solidworks

First Problem ... You can access the Excel commands via the RMB.

Second Problem ... You have to pre-select (highlight) a view to activate the Excel BOM option. Or you do prior to SW06 anyway. I assume SW06 is the same.

cheers
Helpful SW websites  FAQ559-520
How to get answers to your SW questions  FAQ559-1091

RE: My Excel hates my Solidworks

(OP)
Thanks for the quick reply!  The solution to the second problem works. as for the first problem what is RMB?

RE: My Excel hates my Solidworks

Right Mouse Button

"I think there is a world market for maybe five computers."
Thomas Watson, chairman of IBM, 1943.
Have you read FAQ731-376 to make the best use of Eng-Tips Forums?

RE: My Excel hates my Solidworks

(OP)
Thanks MadMango

Thank goodness its monday at least I can blame my "Duh!" on that..   

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources