It'd be nice to have one Excel file that we could alter to control 2 different parts that fit within each other. Can this be done outside (or inside) of an assembly?
Thanks!
RYan
It'd be nice to have one Excel file that we could alter to control 2 different parts that fit within each other. Can this be done outside (or inside) of an assembly?
Thanks!
RYan
That could spell trouble - bad enough with circular rebuilds and now put a clone in the mix ............
Why not do it with global links and or equations
I do that all the time with a master.xlsx multi-sheet spreadsheet that is used to control dimensions, configuration names, component configurations, feature suppression, etc. The cells in the part or assembly design table has links to the master similar to below.
= 'D:\folder\subfolder1\ subfolder2\[xxxxx.xlsx]SheetName'!ColumnName (or cell name)
Cell A1: Configuration Name
Cell A2: = 'D:\folder\subfolder1\ subfolder2\[xxxxx.xlsx]SheetName'! ConfigurationName
Cell B1: Dia1@Sketch1
Cell B2: = 'D:\folder\subfolder1\ subfolder2\[xxxxx.xlsx]SheetName'!Dia1
Cell C1: Length1@Sketch1
Cell C2: = 'D:\folder\subfolder1\ subfolder2\[xxxxx.xlsx]SheetName'!Length1
My tables do not have blank cells in row 1. When I finish making changes to the master.xlsx file, I run a macro that updates the design tables for the parts then the macro updates the assembly design tables. Some of my most complex formulas have circular references by necessity and MS-Excel handles those easily.
I do that all the time with a master.xlsx multi-sheet spreadsheet that is used to control dimensions, configuration names, component configurations, feature suppression, etc. The cells in the part or assembly design table has links to the master similar to below.
= 'D:\folder\subfolder1\ subfolder2\[xxxxx.xlsx]SheetName'!ColumnName (or cell name)
Cell A1: Configuration Name
Cell A2: = 'D:\folder\subfolder1\ subfolder2\[xxxxx.xlsx]SheetName'! ConfigurationName
Cell B1: Dia1@Sketch1
Cell B2: = 'D:\folder\subfolder1\ subfolder2\[xxxxx.xlsx]SheetName'!Dia1
Cell C1: Length1@Sketch1
Cell C2: = 'D:\folder\subfolder1\ subfolder2\[xxxxx.xlsx]SheetName'!Length1
My tables do not have blank cells in row 1. When I finish making changes to the master.xlsx file, I run a macro that updates the design tables for the parts then the macro updates the assembly design tables. Some of my most complex formulas have circular references by necessity and MS-Excel handles those easily.