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!
Bookmarks