I have recently created a new Excel file and saved it to my work OneDrive account.
There are cells within this file, that I have linked to other Excel files on our company's SharePoint.
I opened the new Excel file this morning and opened one of the linked file through SharePoint (online Excel), and the data in my file was not updated. It only seemed to update when I opened the linked file through my Excel Windows program.
Is there a way I can have these linked cells update automatically without having to open the source Excel file?