How can Excel access online data

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



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)





Best video tutorial ever. 3 Excel gurus from 3 continents works on the same workbook at the same time. The best way to collaborate between users. This technique is called co-authoring.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
description for autoplay blocking in settings page
HotCakeX in Discussions on
8 Replies