Below is a list of hints on working with data connnections in power pivot.
When you have a table you pull from another data source be sure not to group the data as the refresh will freeze up!