Do you know how to integrate an ODC connection into an Excel file ? Right now, I have an ODC file in "Documents / My Data Sources', and in Excel, I see that under 'Connection files on this computer'. Is there anyway to add move that connection from 'on this computer' to 'Connections in this workbook' ? Likewise, I can share the Excel file with anyone and they still have that connection.
At time being, I'm the only one that can access the data because the ODC file resides in my computer; and others can't access the data since they don't have that ODC.
Thank you for your help