is it possible to link multiple designtables to a single Excel spreadsheet as a source?

Hi,

I am trying to use the Design table feature with my multiple options model .

This model assembly contains several sub assemblies with variable dimensions individual parts .

I managed to create a design table for each sub assembly that is linked to a central excel spreadsheet  , however I am trying to have the main model assembly to be automatically updated from this central spreadsheet with no success !!

I need to open every sub assembly's design table to refresh , and this become a mess .

Is there a way to update the sub assemblies design tables by updating the central spreadsheet automatically ?

I want to design this central excel spreadsheet to be as an order form for our marketing guys to generate model in SW.

Does anyone have some experience with design tables in assemblies ?

SolidworksConfigurations design Tables