Share via

Microsoft Excel for Mac not storing SQL Server connection password

Anonymous
2018-02-23T19:58:02+00:00

Hello,

I have a file setup in Microsoft Excel for Mac, Version 16.9 with a SQL Server connection that works perfectly for all users. But it asks them for the password every time they open it.

The same file on a Windows PC, using regular Excel, can store the password with a checkbox option to "Save password" in the Connection String.

Is this same feature available in the Excel for Mac software? Or are there plans to make it available in future updates?

Thanks,

K

Microsoft 365 and Office | Excel | For home | Windows

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

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2018-03-01T20:11:18+00:00

    Oh great. The latest build on Insider Fast has broken Get External Data. I'll report that.

    There is more than one way to change the status of whether or not the password will be saved. You can use VBA or you can use the Connection Properties dialog (I'm going from memory here). Try changing that status. If I remember right, you have to use the opposite setting from what you think (tell Excel not to save the password to get it to save the password). It really does work once you get things set up right.

    0 comments
  2. Anonymous
    2018-03-20T17:31:11+00:00

    Hi Katarina, I have the same issue. Were you able to resolve it?

    0 comments