×
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

linking of part family to external spread sheet.

linking of part family to external spread sheet.

linking of part family to external spread sheet.

(OP)
i want to drive the value of a cell in part family from an external excel file. When both the spread sheet files are open and i make any change to the source file the value gets updated in the part family.  But if the part family spread sheet is closed and i make any change in the source excel sheet then when i open the part family spread sheet it does not update. Apart from that the link between the  two spread sheet gets automatically broken.

Please some one guide me.

RE: linking of part family to external spread sheet.

The part family spreadsheet appears for all the world to be embedded inside the UG file. How UG stores the data is not clear but it probably goes some way to explaining why links to external files would be broken.

You can certainly save a copy of the file make external changes to it and then paste across the values when next you open the part family if that is what you wish to to.

Hope this helps

Hudson

RE: linking of part family to external spread sheet.

(OP)
Thanks Mr Hudson for ur tips.
Actually I am managing with a similar technique like what u have suggested. But it would have been of great help if the part family values could be driven without any breakage of link from external excel sheets..

RE: linking of part family to external spread sheet.


 Hi rk,

  I guess you might have used Data->Import External Data->Import Data in Excel to achieve this. To establish the value refresh link, you should check ON "Enable Background refresh" and "Refresh Data on file open" in the properties option while setting the import data options.
 
 For more clarity refer this link :http://www.excel-vba.com/excel-2b-import-external-data.htm

 This should help...

 HariharanB

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