Excel 2010 won't remember password when importing data

1

1

After connecting an Excel workbook with an SQL server (within a company network, over a static IP address, using the data connection wizard within Excel), if I close the workbook and reopen it, it requires me to type in the password for the server again.

Is there a way for the connection to always remember the password, not just the username?

kikx

Posted 2014-01-15T07:41:38.213

Reputation: 21

Did you allow saving password in the connection wizard?

– Raystafarian – 2014-01-15T11:30:41.530

No answers