excel - Is it possible to have 1 pivot table from 2 workbooks? -

i've been using excel lot lately , i'm not quite familiar pivot table. possible me combine 2 workbooks 1 pivot table? first workbook days of leave of employee , second 1 days employee present. have similar fields internal id. wondering if there's way combine 2 workbook make 1 pivot table only. tried connection in excel helps connecting 2 workbooks make 2 pivot tables. appreciated. thank in advance!

you can use free add-in power query excel 2010 , 2013, or built-in & transform in excel 2016 combine data different workbooks.

create query first workbook table , save connection only. create query second workbook table. make sure columns have identical names , of same data type. click append combine first query, load workbook , create pivot table usual.