remote pivot table

[MetLife]

Hi,

I have 3 excel files that are about 100MB. All I need to do is have a pivot table, sum up the fields using some rudimentary logic.

Is there a way to do this with a pivot table? I want to keep the files external because they are large.

Is there a better way to do this?

Thanks,