Open all linked files and close them.
 

Hello.

I need to know how to do the following.

Open each linked file in a workbook,
Update Linked Data,
Save Changes,
Close all linked documents.

Thanks. This is to work around the cant update data is more then 2 linked
sheets away.