extracting powerpivot data to excel using evaluate

[masplin]

I have been using office 2010 and powerpivot with linked excel tables. Someone helpful taught me that to extract the powerpivot data into an excel table I could double click on any cell in a pivot table then go to data/connections/properties/definaitions and change the text in "command text" box to evaluate summarize etc etc. This works absolutely perfectly.

I am just experimenting with Office 365 Pro plus Excel 2013 using a powerpivot model built from an SQL query. When I try to do the same thing I can't see anything in connections that refers to this new sheet and can be edited. Is there some other way to extract data from the powerpivot model please?

Thanks
Mike

 

[masplin]

hmm Exisitng connections is there but greyed out?

 

[Laurent C]

Screenshot?

 

[masplin]

PP Connections | Flickr - Photo Sharing!

Tried various tabs and all the same.

 

[masplin]

PP Connections | Flickr - Photo Sharing!

Tried various tabs and all the same.

 

[Laurent C]

It looks like the current cell belongs to a pivot table or a table object. Try to select a free cell, and look again.

 

[masplin]

What an idiot I am!!! Thank you so much for having the patience to point me in the right direction.

Mike

 

[Laurent C]

No problem. Most issues are just about missing small things