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>

 

[Art15651]

Did you "refresh" in the Excel window? That should make your measures visible to Excel. And the cube formulas mentioned above are to get at the PowerPivot Data cube which is created when you have data in PowerPivot (in other words, even though you got data originally from a cube, once you put it in PowerPivot, it creates another cube that you can access with cube formulas). Try it, you'll like it!