×
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

Tabular Note Excel - Data > Validation > List

Tabular Note Excel - Data > Validation > List

Tabular Note Excel - Data > Validation > List

(OP)
Experts,

I often use data validation in Excel to limit what users can add to the spreadsheet.

Is there any way that I can use validation in Excel behind a Tabular note and then make this portable via copy/paste or better still by adding as a template on the resource bar?

On my master part I create a table, edit this via spreadsheet, add a list of values via Data > Validation > List, key in a list of comma separated values or point to a list in the workbook, I now select a relevant cell in Excel and select a value from the drop down list. If I leave Excel, the tabular note updates perfectly.

All ok so far.

If I copy the table and paste it in to a different file, the spreadsheet behind the tabular note is no longer showing options, just the value that was set when the table was copied. Likewise if I import the values to a new spreadsheet from a saved file.

I suspect this is an Excel issue.

Any ideas or suggestions as to how I can achieve my goal by a different route?

Thanks in advance.
 

RE: Tabular Note Excel - Data > Validation > List

(OP)
This might be useful, but I suspect it's version independant

NX6.0.2.8
NX5.0.5.3
TC10.0.2.4
Excel 2003

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