<div>
<div class="content wysiwyg-content">
Hi, <br />
<br />
I have an excel file that is connected to a sql database. I am able to refresh the data when working from my workstation, but when anyone else tries to refresh the data from their computers, it produces an error message stating that the user does not have access.<br />
<br />
I have tried sharing the odc file and editing it to not include information regarding my workstation.
</div>
</div>


Hi, 

I have an excel file that is connected to a sql database. I am able to refresh the data when working from my workstation, but when anyone else tries to refresh the data from their computers, it produces an error message stating that the user does not have access.

I have tried sharing the odc file and editing it to not include information regarding my workstation.

External Data Connection producing error

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.