Data Connections not Saving in Workbook -- HELP

Thomas2016

New Member
Joined
Mar 1, 2016
Messages
12
I've created a workbook with a simple data extraction from a SQL server that loads to a Table. It works great on my computer, but when I try to distribute it to other people, the Table's connection to the SQL Server query is lost, so they are unable to update the data in the table.

The workbook is not using a Connection File to get to the data. By the way, the Connection name does still appear in Data>Connections, but it is 1) disassociated from the output table, and 2) all of the properties (including the SQL query itself) have been cleared from the Connection>Properties.

Any help would be GREATLY appreciated.
 

Forum statistics

Threads
1,084,856
Messages
5,380,319
Members
401,664
Latest member
traveler84

Some videos you may like

This Week's Hot Topics

Top