Home

How can Excel access online data

Rui_Jorge
Occasional Visitor

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 is centralized (One Drive?) with data that is used by each one of those Excel spreadsheets. This way I can update this spreadsheet and have everyone to access update data.

I was able to generate a link to share with other users (and they can open it). But I am being unable to have their spreadsheet to load the data from the shared spreadsheet.

How can I do it?

Or is it better to have their Excel spreadsheets to access any different format of data file?

Thank you

1 Reply

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)

 

 

 

 

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies