The following macros are only supported from the web portal: @CurrentIteration, @CurrentIteration +/- n, @Follows, @MyRecentActivity, @RecentMentions, @RecentProjectActivity, @TeamAreas. Queries that contain these macros don't work when opened in Visual Studio/Team Explorer, Microsoft Excel, or Microsoft Project.