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?