Import data from excel on Sharepoint online into another excel on my com

[abschy]

Hi all,

I've been trying to figure this out for the longest time but havent managed any progress.

I have an excel sheet (Excel A) that i update regularly (ie daily) that is put on my company's sharepoint/microsoft teams for others to refer to.

However, i am working on another file (Excel B) that requires the data from Excel A for me to sort out by categories. Excel B is to be saved in my own laptop and should not be put online on sharepoint.

Is it possible to use microsoft query to link the data and for it to be updated as i update Excel A? I've tried microsoft query and it only works if Excel A is in my own computer. The sharepoint online option doesnt seem to work for me..

Would appreciate any help!!!

Thank you all!
Best,
Abigail