Microsoft Dynamics AX 2012 R2 offers a new functionality of ad-hoc reports which gives business users the tool to generate reports from Microsoft Dynamics AX using Microsoft Excel Add-In, it is requires to enable this function, through – File- Tools-Options
Under General-Miscellaneous-Workbook support Refresh:-
Never
When possible
User group: DynamicsArabia