Importing Serveral Files into Power Pivot

[howard]

I would like to know how to select several files to import into Power Pivot at once in a particular folder i.e I do not want to select all the files in a folder, just certain files

I select Data > Get Data from File > From Workbook

When doing so, it only allows me to select one file

 

[alansidman]

Instead of from Workbook, select From Folder. You can then filter out or in the workbooks.

 

[howard]

Thanks for the advise