Share via

Excel data connection passwords

Anonymous
2019-07-11T18:17:10+00:00

I am trying to create an Excel file that uses a data connection to an SQL Server using database credentials so that I can give the file to another user and they can refresh the data themselves.  I can create the connection, provide the database credentials, and refresh the data myself but the credentials disappear when someone else opens the file and tries to refresh the data.

Any suggestions?  I've seen some posts about a "save connection password" option when you setup the connection, but I think the walkthroughs I find are for older versions of Excel.  They don't match up with what I'm seeing when I try to follow along.

Any advice is welcome.

Microsoft 365 and Office | Excel | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-07-11T18:42:17+00:00

    Hi,

    Although I'm not familiar with Sharing connecting files, Here is an official article especially under Sharing connections which say ODC files are the recommended method for connecting to data and sharing data.

    https://support.office.com/en-us/article/overview-of-connecting-to-importing-data-c0ad7aec-ff1a-4e48-9c21-dc18a102433f#bmworking_with__external_data_connectio for your reference.

    Another thread :https://stackoverflow.com/questions/36890444/how-to-share-an-excel-file-that-has-a-sql-query-connection

    Best

    Was this answer helpful?

    0 comments