Inventor General Discussion

Distinguished Contributor
Posts: 193
Registered: ‎05-06-2005
Message 1 of 4 (206 Views)

Parts List Line Item Visibility

206 Views, 3 Replies
09-13-2012 12:50 PM

Is there an application or document setting that will make the default state of a row in a linked excel file used in a parts list default to "off" (not visble)?

More specifically, make this apply to added rows.

We have finish schedules in excel that everyone links a parts list to whenerver they need to display a finish schedule on the idw. However, when we add rows (new finishes) to the the excel finish schedule, they get displayed on the idw parts list next time the idw updates wether they are needed or not. Our practice is to only show finishes that are used on the drawing - so frequently a large portion of the whole finish schedule needs to be set to "off" or invisible.

Any thoughts?

Posts: 181
Registered: ‎10-07-2011
Message 2 of 4 (199 Views)

Re: Parts List Line Item Visibility

09-13-2012 02:28 PM in reply to: Myoula

Not sure if this is what you are asking for:


I would put the parts you want to hide on its own layer in the idw. File. Write a little code in the rules to make a button turn the layer on and off whenever it’s needed.


Hope this helps…

Product Support
Posts: 762
Registered: ‎11-22-2011
Message 3 of 4 (171 Views)

Re: Parts List Line Item Visibility

09-26-2012 03:46 PM in reply to: Myoula

Did you mean that you're inserting a general table with the finishing schedules spreadsheet? I'm not aware of a mechanism to prevent the update or hide new entered information.


You may try using Tools ribbon > Options panel > Links > Break Link to remove the relationship to the original spreadsheet. However, after this is done the table will have to be updated manually. 

Nathan Chandler

Distinguished Contributor
Posts: 193
Registered: ‎05-06-2005
Message 4 of 4 (159 Views)

Re: Parts List Line Item Visibility

09-27-2012 06:48 AM in reply to: Myoula

Yes, thanks, you have the idea, Better yet would be to have a setting so that, once the visibility state of a parts list is set, any new rows detected when the parts list is updated would have the visibility state set to "off" by default - then this whole question goes away and the parts list can remain linked, no need for manual edits. I would much rather have to turn a few extra rows on if needed than to ALWAYS have to turn new ones off - this frequently causes parts lists to grow massively in size and overlap other views, text, etc, Most of the tiime you are not even aware that this is happening until you print.

Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.