AppleScript: Open and save excel files

Hello -

I have a bunch of excel files that are linked to each other, so when I update the main file, I need to open and save each of the files linked to this in order for the links to update.

This is something I need to do daily, and opening and saving each of the files manually takes a lot of time when I guess this could be easily automated.

I would need a code to do the following:

• open file1.xlsx

• select "update links" in the pop up when opening the file

• save file

• open file2.xlsx

• select "update links" in the pop up when opening the file

• save file

• open file3.xlsx

• etc...

I appreciate the help, if someone has an east solution for this :)

Thanks