Excel Power Query : Data not refreshing on Merged Data from more than 2 files

Occasional Visitor

I added data from different files by using power query on 3 excel files. I have set the formula to select only the excel files from a particular folder. When i created the query, i tried adding an extra file & refreshed the data, everything was flowing in. But once i saved & closed the file having the merged data, i added another file to recheck if the merged data was working. Now when i open the file & use refresh option, the new file data is not getting added to my existing query with error as Data not downloaded or File is in use.

1 Reply

@SmithnSmith Can you give access of Anydesk and show the error what actually you are facing and  we will surely try to find a solution for your problem .

 

Just tell me when you are online and connect with me on my Mail id