Excel 2010 - how to send a file to others with a data connection to SQL Server
I'm using Excel 2010 with a data connection to a sql server on my domain. I'd like to share a workbook with other users so they can see refreshed data upon opening. The users don't have a SQL server logon. What are the steps to send a copy of the workbook to other users so they can use it with minimal fuss? Do I need to install an .odc file on the user's desktop?
This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.