Trought a remote conection with my server (SERVIDOR) I made an excel workbook whit five different querys (made with the get external data tool in excel) and all remote users that connect to my server could use the workbook without problem.
My problem starts when an user on the local network (not remote) try to open the same workbook. (I tried with a shorcut and with the file itself in the local computer)
The excel fail to connect to the database and a Window "SQL SERVER LOGIN" is open with the name of the server and all details for the conection and the box "use trusted connection" is selected...the only way to get the querys working is to uncheck this box and write "sa" in the user field....and this must be made 5 times (one for each query)...
How should I fix this in order that the computers in the local network could connect without have to login each time the workbook is opened ?
See attached picture of the windows I´m talking about.
Thank you for your help.