How to set up a data source in Excel as a network connection file?

Question

excel

How to get DB content directly from MSQ SQL to Excel? Configured on the Data tab - Connections from other sources a request for obtaining data. Now it is in the book. Connections file on this computer. There is also an item - Connection files on the network - it says that no data was found. How can I upload the created connection to the local network (a simple grid with a domain for 30 PCs), so that users can choose a connection on the network and take data from the server?

spoiler

Answer 1

Network connection files. This list is generated from an Excel data connection library (DCL) in a Microsoft SharePoint Services site.

Which, of course, you don't. So don't use "connection file".
Connect directly: "Data", "Get Data", "From Database", "From SQL Server Database":

Set up a connection

Users will not be able to

The setting is saved in XLSX. That is, put it in a shared folder and it will work on other computers immediately. Or make a template out of it, and other users will use it for their files.
If you copy the file ODCfrom the folder %USERPROFILE%\Documents\Мои источники данныхto others, they will still import the data themselves.

Answer 2

And if you set it up once, save the file as a template and replicate it among domain users, for example, with scripts?