Update Data Excel from another file Office 365

%3CLINGO-SUB%20id%3D%22lingo-sub-1923368%22%20slang%3D%22en-US%22%3EUpdate%20Data%20Excel%20from%20another%20file%20Office%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1923368%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20I%20automatically%20update%20data%20from%20external%20files%20without%20opening%20the%20file%3F%3CBR%20%2F%3E%3CBR%20%2F%3EMaybe%20a%20script%3F%3CBR%20%2F%3EBecause%20I%20cannot%20do%20it%20through%20Excel%20Online%2C%20there%20is%20no%20multi-user%20support.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20I%20put%20an%20update%20in%20the%20file%20every%201%20minute%2C%20for%20example%2C%20then%20it%20does%20not%20update%2C%20because%20the%20file%20can%20be%20used%20by%20multiple%20users%3CBR%20%2F%3EHow%20do%20you%20automate%20this%20process%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20file%20is%20initially%20in%20the%20Sharepoint.%3CBR%20%2F%3E%3CBR%20%2F%3ETakes%20data%20from%20another%20file.%20Both%20files%20are%20synced%20on%20your%20computer%20and%20are%20in%20File%20Explorer.%20But%20it%20does%20not%20change%20anything%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1923368%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

How can I automatically update data from external files without opening the file?

Maybe a script?
Because I cannot do it through Excel Online, there is no multi-user support.

If I put an update in the file every 1 minute, for example, then it does not update, because the file can be used by multiple users
How do you automate this process?

The file is initially in the Sharepoint.

Takes data from another file. Both files are synced on your computer and are in File Explorer. But it does not change anything

0 Replies