We are doing migration of our VBA application from office 2010 to 2013.

Excel stops working and crashes for a MDX query, when we run the same MDX query from SSMS it is fetching the results.

Excel is not crashing once we start debugging the VBA code and complete the debugging cycle.

MDX query that gets fired is

SELECT NON EMPTY ( [SEASON].[SEASON].[SEASON], [SEASON].[SEASON PROG].[SEASON PROG] ) ON ROWS, { [MEASURES].[Return_1] } ON COLUMNS FROM [RP_MASTER]

Could you please help?

Regards,
Mahesh