Forum Discussion
working with multible sheets
i have attempted to create 1 sheet from multiple sheets using =Excel.CurrentWorkbook() to bring all the sheets together in a Query. the result is i am getting some of my results listed twice .. i b...
BillHull The first time you do this, the workbook indeed only contains the tables you want to combine. When you then load the combined table back to Excel and refresh the query it picks-up the PQ generated table(s) also, thus duplicating everything. Go into the PQ editor. In the Source step, filter out the table(s) that is(are) created by PQ. Close and Load. All should work just fine.
