When users open a report link from a SharePoint e-mail alert, they can choose how they want to view their personalized view of the report. Many times users want to open these reports in Microsoft Excel to perform ad-hoc analysis, like “what if” or apply after the fact formatting.

http://www.youtube.com/watch?v=XAgx0udqqd0&feature=youtu.be