PowerQuery opens connected files

Hello,

So I connected 2 files in query and then appended them. After that, I loaded the results to a table. Every time I attempt to refresh the table, a window prompts up asking for the password of both files and after typing it, it opens them both. Even if I remove the passwords from the files, it still opens them every time I refresh. What is the cause of this? These 2 files are quite large so waiting every time for them to load is time consuming. I have managed to append in query other files in the past, without having this issue, everything working successfully without opening the excel files every refresh.



Thank you!

Thank you very much for your response!

I have to say that this option is unchecked. The problem was there when there were no passwords aswell. When the file was unlocked, as soon as I clicked refresh, it opened the files. I added the passwords in the meantime to not ruin something by accident. Now if I remove the passwords from both files, the refresh still opens them.

Thanks

Thanks!

I will give this video a try and if not I will start over with files without passwords.


Many thanks again