×
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

'Lock to Anchor' for Excel-Based Revision Table

'Lock to Anchor' for Excel-Based Revision Table

'Lock to Anchor' for Excel-Based Revision Table

(OP)
Is it possible in a SolidWorks Drawing to lock a revision table?  I know it's very possible to lock a Bill of Materials - maybe a macro to lock multiple tables?

The company I'm with currently uses Excel-based tables - this might be part of the problem.

RE: 'Lock to Anchor' for Excel-Based Revision Table

Have you set the Anchor Point in the Edit Sheet Format mode, and the Excel BOM option to Use table anchor point?

RE: 'Lock to Anchor' for Excel-Based Revision Table

(OP)
Yes - to the Excel BOM option - but I don't have a similar option for my revision table.

RE: 'Lock to Anchor' for Excel-Based Revision Table

Sorry, my remaining two brain cells got stuck on the BOM after seeing it in your post.

You are correct, Excel revision tables do not have that option.

Have you tried the SW Rev and BOM tables recently? You (or the company) may be pleasantly surprised. The SW BOM now has a lot more Excel functionality.

RE: 'Lock to Anchor' for Excel-Based Revision Table

(OP)
CBL - you're 'preaching to the choir' bud.  I know (from my last company - and messing around on my own) - that both the SW rev table, and the SW BOM are definitely the way to go.  

[Also, experience tells me that you mix applications {in this case SW and Excel} only as a last resort.]

RE: 'Lock to Anchor' for Excel-Based Revision Table

Agree with CBL - The SW rev table is very good - automatic incrementing of the rev block is a nice feature if you link it to the Revision custom property.

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