Hello,

I am running into a problem where Excel 2010 is freezing when I try to work with data coming from a Microsoft Dynamics AX 2012 R3 pre-built cube.

What is happening is that when I go to add a second dimension to my pivot table, excel locks up and becomes completely un responsive for at least 2 hours.  If I add the dimension to the table before the measure though, everything is fine.

For Example, I am trying to build a sales report with the product name and customer name as dimensions, and Sales as the measure. If I add the product name to my pivot table as a column and then sales as a measure, Excel will freeze when I try to add the customer dimension. However, if I add both dimensions to the pivot table first and then the measure, Excel seems to work fine.

I am a bit stuck on where to go next to troubleshoot, so any help would be greatly appreciated.

Thank you,

Phil

Hi Phil,

Based on your description, when youre working with the data of Microsoft Dynamics AX 2012 R3 pre-built cube, excel 2010 no responding.

I suggest you to collect the event log and provide us with the whole error messages of event log.

Steps of collecting event log:

Open Event Viewer to check whether there's any error about the Excel/Word crash issue.

Press Win + R, type "eventvwr" in the blank box, press Enter. In the Event Viewer, browse to Windows Logs -> Application, there may be some errors after the crash.

Please try to collect this event log and post the whole event log message to me. I can get more information about your issue from this message and help you solve it.

Regards,