Possible to use PowerPivot NOT as a pivotTable in Excle?

[rv7a99cv]

Hello, this is my first post here. I have a general question. Let’s assume I have an Excel document with 3 worksheets, Wsh1, Wsh2, Wsh3ImportedData (formatted as a table). Wsh1 and Wsh3 are using the data from Wsh3ImportedData for calculations, charts and graph. Each time there is a manual process that I go and get the external data copy/paste into the Wsh3importedData. I love to use PowerPivot but the only result I get on an Excel worksheet is to use it as PivotTable. Is there any way that I can use the PowerPivot data in my Excel worksheet like my Wsh3importedData?
Thanks in advance.</SPAN>

 

[wigi]

Hi there

You can use it as a Table, or in a number of other ways.
If you go to a new sheet, then Data > Existing Connections > Tables,
you will see the possible connections. Choose the one you need. In the next scree, highlight that you want to use the data as a Table (first option).

 

[rv7a99cv]

Perfect, I didn't think about it at all. Very good info and this is what I was looking for. Now I need to see if there is a way I can have users to enter parameters....
Thank you so very much for your info and help.

 

[Badrul]

Is this an Excel 2013 only feature? I don't get the table option in 2010.

 

[wigi]

I cannot see in an Excel 2010, but I'm quite sure it is new to 2013.
In 2010, PP was merely an addon, while in 2013, PP is more embedded into Excel.

 

[RoryA]

In 2010 you could try Power Query instead, if you have the correct SKU of Office to use it.

 

[rv7a99cv]

If you have Excel 2010 you can get the add-in and try it. There are (I think) 3 versions of PowerPivot are out there. PowerPivot 2008 R2, PowerPivot 2012 and PowerPivot 2013. PowerPivot 2013 is included with Excel 2013. The difference so far I noticed was only the looks which I noticed. Again, I used it with Excel 2010 and worked very well no issue at all. After download and install make sure to go to add-ins (excle) and check the checkbox.

 

[rv7a99cv]

Hi there

You can use it as a Table, or in a number of other ways.
If you go to a new sheet, then Data > Existing Connections > Tables,
you will see the possible connections. Choose the one you need. In the next scree, highlight that you want to use the data as a Table (first option).

Hi Wigi, well I hit another road block. With the example above you provided I can use the existing connection to my PowerPivot and get “Original” data as a table into my Excel worksheet BUT I need data from my PowerPivot.
For example let’s say I used my connection within PowerPivot and retrieved ID, FirstName, LastName, City, State, zip and phone number into my PowerPivot. I hide the ID, FirstName and LastName and inserted one new column called Name. </SPAN></SPAN>
Now I have Name (LastName, FirstName), City, State, Zip and phone.</SPAN></SPAN>
If I use the existing connection (your example) then in my Excel worksheet I see the original items not the modified one column in PowerPivot. </SPAN></SPAN>
I need to get my PowerPivot data as a table into my Excel workbook. Any other way to do this?
Thanks so much.</SPAN></SPAN>

 

[Jacob Barnett]

What you are looking for is cube formulas, there are a bunch of posts here: Cube Formulas « PowerPivotPro

They aren't totally intuitive but once you get past the initial hump they are immensely powerful.

 

[rv7a99cv]

What you are looking for is cube formulas, there are a bunch of posts here: Cube Formulas « PowerPivotPro

They aren't totally intuitive but once you get past the initial hump they are immensely powerful.

Jacob,
I am not using cube formulas. I am accessing Cube data with PowerPivot, make some changes with DAX and then get data into Excel worksheet as a table. The issue is when I hide columns in PowerPivot they are going to show in Excel and also if I create measures inside PowerPivot they are not visible in Excel.