excel - How to import data from a worksheet to the powerpivot from the same workbook -

i wants import data worksheet in workbook "\foo.xlsx" powerpivot in same workbook "\foo.xlsx".

when try give connection same workbook gives error:

the file have chosen in use. please close file before import. 

is there way solve problem??!!

thanks

please use create linked table found in powerpivot tab