question

MarcelVanMensel-2239 avatar image
0 Votes"
MarcelVanMensel-2239 asked emizhang-msft answered

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

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

office-excel-itpro
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@MarcelVanMensel-2239, For our issue, it seems to be with excel related. Given the situation, we will help to change the tag to "office-excel-itpro" to get correct support. Thanks!

0 Votes 0 ·

1 Answer

emizhang-msft avatar image
0 Votes"
emizhang-msft answered

Hi @MarcelVanMensel-2239,
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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.