I have a spreadsheet with multiple arrays pointing to excel sheets saved in Teams. When someone uses the cloud interface to save, and doesn't open excel in the app itself, the array doesn't know/can't see changes. This means I need to go into each of these spreadsheets, open in the excel app, save, & close in order for the array to work properly. This defeats the purpose of the array! Is there a workaround for this, or does anyone have a suggestion on a macro that would do the open, save close automatically?

Using Office 365.

Thanks,
Kelly