GetData: Consolidate Excel Sheets using Power Query - Getting Error

[Toots912]

Hi, 

I was combining worksheets in one excel file using GetData>From other Sources>Blank Query. I entered into the formula bar "=Excel.CurrentWorkbook()" to pull all the worksheets in the workbook so they can be combined as one data source for creating pivot tables.  Instead of showing "table" in the content column, it showed "error". I'm not sure what's causing it as my two worksheets have the same headings and number of columns. I don't know how to fix this. Am I missing a step or doing something wrong?

[#2]

@Toots912 

_FilterDatabase is the internal name which Excel gives to filtered range. Power Query doesn't work with such names. You need to name explicitly your ranges. As variant you may name entire columns, e.g. range1 as Sheet1!$A:$F and filter null when combine.

[#3]

I got it. Thank you.