Data download

[beng986]

Morning,

thanks in in advance for your help.

i download a lot of data which exists comes in an excel fromat. About 1000 separate excel sheets. If I were to save over / replace the existing file everytime I download the latest excel, would powerpivots be able to pull out the same data?

It would have to be dynamic as the number of rows alters.

Thanks

 

[scottsen]

It seems likely that you want to investigate Power Query.

 

[beng986]

Thanks it was.