• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 50
  • Last Modified:

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?
1 Solution
Hypercat (Deb)Commented:
I can't think of any way you could do this.  You can send static data that has been extracted from the SQL database, but they wouldn't be able to get fresh data.  They'd have to have an ODBC connection to the SQL server in order to refresh the data.  So, even if they don't have their own unique login, they'd have to have at least a shared login that was used just for the purpose of refreshing the data on this spreadsheet.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now