Forum Discussion
Rui_Jorge
Feb 25, 2019Copper Contributor
How can Excel access online data
I want to create an Excel spreadsheet (either using Excel Online or desktop Excel) that several colleagues use at home (so each one would have a copy). But I also want to have one unique table that ...
Wyn Hopkins
Feb 26, 2019MVP
Hi Rui_Jorge
You could set it all up in the one file and have everyone access it at the same time, easy in Excel online and with O365 it's now possible with Desktop Excel
https://www.youtube.com/watch?v=8tPoyn55LNU&trk=public-post_share-video-embed_share-article_title
Otherwise you could use Power Query to connect to the master file and pull the data in to the separate files. The users would need to click the refresh button (and be working in Excel Desktop)