multiple solidworks files with reference to a single excel file, possible?

[e.barbiani]

in order to speed up the design of some parts, we would like to create "masters" of which to make a pack and go.
these "masters" (of the parts built with solidworks 2016) should be updated taking as reference a single excel sheet.
I wanted to know if you ever collided with such a problem, if it is possible and what measures to take.

thanks in advance for any response.

 

[MassiVonWeizen]

just use an external data table

 

[e.barbiani]

just use an external data table

Can I ask you to argue your answer better?
I would like to split the references of each file to a single sheet to prevent the references from being confused. Is that possible?

Thank you very much in advance

 

[MassiVonWeizen]

you have asked a simplified question and that is the answer.
we start from the beginning:
Can you use solidworks well? What is your knowledge?
Can you use the data tables?

 

[e.barbiani]

you have asked a simplified question and that is the answer.
we start from the beginning:
Can you use solidworks well? What is your knowledge?
Can you use the data tables?

solidworks I think I know how to use it pretty well, the data tables I know and are able to set the various parameters of the data table in order to change the various parameters of a part.
It's the first time I've been having to edit various parts from a single file, which is why I asked the question.
I apologize for not being clear and sufficiently complete.

at the moment I created the external excel tebella with various parameters and links to part 1.
I would at this point (in a new sheet) add references to another file "part 2".
is it possible (without creating confitti)?
can you do so that the file will automatically update without having to open the excel table from inside solidworks save and update?

 

[MassiVonWeizen]

for new sheet do you always mean in excel file extension?
If so I do not think it is possible because, from the tests I have done, solid reads the first sheet with the corresponding useful data.
I did this test: after creating the part and data table with the linked variables I saved the table externally and deleted the inside one to the part. I changed a value in the excel and reset it using the file option and checked that it was updated. at this point in the excel file I created 4 copies of the first sheet (containing the data connected to the part) and in each I deleted something leaving intact the last (in the first I deleted everything, in the second I deleted only the values, in the third I deleted the headers of the columns). at the opening of the part the file is updated by automatically reading the last full sheet of all data.
to further test I made a sheet excel with two sheets with different line header (the line containing values and which recalls the sheet configuration name1=day and sheet2=anselmo) assuming that the sheet containing the configuration name corresponds to the part; opened the file that had its own anselm name on the second sheet loaded the first sheet going to create a new giorgio configuration. on the contrary opening the file giorgio has not been created anselmo configuration
from these summary tests I deduce that it is not possible to create a multisheet data table as only the first useful sheet will be read.
except for what is said above a possible, but laborious, way could be to create an excel master file and then a series of excel files, with the values connected to the master, dedicated to each part.

 

[e.barbiani]

after several tests I agree with her that the best solution in terms of clarity and simplicity is to update the various excel sheets (of the parts) making them point to a single master excel. I thank you very much for the availability and I apologize for not being clear. . .