Excelisfun has a video on this topic.
https://www.youtube.com/watch?v=0NX-GctfZuU
I performed the steps and had my query set up. Then I added next month's sales file to the import folder and hit data refresh. The query only pulled in 1 of the files (oddly enough, the most recently added).
Why isn't it pulling everything in the folder like it normally does?
Also, I tried clicking on the double down arrows to expend the data in the binary column, and it gave me the following error: "We cannot find a table named table2."
https://www.youtube.com/watch?v=0NX-GctfZuU
I performed the steps and had my query set up. Then I added next month's sales file to the import folder and hit data refresh. The query only pulled in 1 of the files (oddly enough, the most recently added).
Why isn't it pulling everything in the folder like it normally does?
Also, I tried clicking on the double down arrows to expend the data in the binary column, and it gave me the following error: "We cannot find a table named table2."
