1st time Power Pivot User - Please Help

[lwilt]

I'm trying to set up a power pivot to dump order data into a pivot table. When I go into Manage in the Power Pivot I can not find the existing connections set up. When Normally using excel and pulling in data I just go to data>from other sources>MS query and I can see the database connections I'm trying to get to so that I can bring in the info I need. What do I need to do to have those same connections come up in Power Pivot? Can someone please walk me through the set up process for how I need to do this.

Also, I would need to bring in another excel file, items I only want orders to show if they have those items, into the power pivot. How would I do that? I assume once it's in there just setting a link with it and the table that has the data coming into the power pivot to get it to only show those orders.

[lwilt]

Also posted this topic at:
http://chandoo.org/forum/threads/1st...se-help.29536/
http://www.mrexcel.com/forum/excel-q...ml#post4526210