In one of our Visual Studio ALM Ranger Team Project Collections we currently have 20+ active Team Projects and often ALM Rangers are assigned tasks in multiple solutions.
SIMPLE! I love this environment!
So can I query across team projects now in Excel in Dev11? If so...amazing!!! Can you share the way it works for excel based queries when you update?
Not sure where Excel came up, but the feature I am using above works in both Visual Studio and the Web Client. The screen shots are from the latter. Opening such a query in Excel has and is failing with the error: "TF208015: You are trying to add work items that are not in the selected team project for this Microsoft Excel file".
So, to cut a long story the answer is "no".
Thanks for the answer Willy. Major bummer that excel support hasn't been fixed so that you don't get that error message. :-(
There is another way to see related project queries, and even get them into Excel:
it is a little bit cumbersome, but it works… open the query in a web-browser --> export to email or to report --> save to HTML -->open in excel, e voila there you go.