Dec 05 2019 10:01 AM
Dec 09 2019 01:12 AM
@NerdyBen Hi, was the power query running when you were opening the file?
If so, it's not a bug. Power Query will run into error if the base file is opened while running the codes (even background) so my best practice is not to keep the base files open until power query has ran and settled.
Otherwise, it might be a possibility that your query is huge (especially if it is loaded to a worksheet) and eats up the memory to open the other excel files.
Dec 10 2019 02:16 AM
@crazyshoots Thnx for the reply. The power query was not running: it's window was closed. I know I can't even go back to excel while running PQ, because I have to close it first (close&load). Secondly, the query is not huge, about 10k-15k rows, 10 columns. It does load it to excel though, but it should be able to handle that. The file sizes are all under 10 mb and it happens with multiple different files with different queries.
Mar 10 2022 01:50 PM
@NerdyBen Did you ever solve this? Thank you.