Forum Discussion
Power Query Not working for a single worksheet within multiple workbooks
I have been using power query for a few weeks now to merge about 30 workbooks into 1. They have about 5 tabs within each workbook. I am pulling tabs 1, 2, & 3 from the 30 different workbooks, but for...
That's not clear do you check tabs by their order or by their names. Sheets "A and B" and "A and B" will be different ones since they have different names. If you change the name compare to previous time Power Query could work differently.
Also you may try to select not "First file" as the sample. but any other one.
You may try to clean the cache.
Perhaps something else, very few details.