I created a workbook with automatic links from a SQL database via ODBC.

Marcel Van Mensel 1 Reputation point
2021-09-12T09:51:32.527+00:00

I created a workbook with automatic links from a SQL database via ODBC.
This workbook must be used by 5 people individually on their own computer.
I can update the link on my computer without any problems,
but when i want to update workbook on another computer he gives an error message that he can't find the database
Although all the settings that need to be set (ODBC, SQL etc.) are set on all computers as on my computer, he continues to give this error message.
I can access and view the database on each computer individually, but the links don't work.
Does a setting still have to be set somewhere or do I have to call up the workbook links on each computer separately?
Is the intention, if something is adjusted to the workbook, a copy is simply sent to these five other users and that they can automatically perform the possible update of data from the database themselves.
Gladly answer Marcel

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,687 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 23,586 Reputation points Microsoft Vendor
    2021-09-13T07:59:04.243+00:00

    Hi @Marcel Van Mensel ,
    What kind of authentication method did you use to connect to SQL?
    I suggest you check the authentication method you're using, you can change the method to another and check the result.
    Any updates please let me know and I'm glad to help you.


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.