ODBC Queries requiring confirmation, not remembering password? Grrrr! Help! :)

[matthewbutterworth]

Hello everyone,

I'm having a problem with Excel remembering query passwords and requiring confirmation when a query is refreshed, even though the password is there and the remember password box is indeed ticked. I've recorded a video so you can see what I mean. As you can see, this is a pain when there are a few queries. Does anybody know a way around this? Seems odd.

https://youtu.be/Gopb_Q-4_pc

Here's hoping you can help.

Many thanks,

Matt