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.
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…
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.
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.