The Grid to Excel functionally returns no data in Dynamics SL

  • Article

This article provides a solution to an issue where the spreadsheet contains no data when you use the Grid to Excel functionality in Microsoft Dynamics SL.

Applies to:   Microsoft Dynamics SL 2011 Service Pack 2, Microsoft Dynamics SL 2011 Service Pack 1, Microsoft Dynamics SL 2011
Original KB number:   2894373

Symptoms

When you use the Grid to Excel functionality in Dynamics SL, you notice that the spreadsheet contains no data. Additionally, column headers incorrectly read Column1, Column2, and so on.

Cause

This problem occurs when the ACDManagedAddin.Connect Excel add-in is enabled.

Resolution

Disable the ACDManagedAddin.Connect Excel add-in. To do this follow these steps:

  1. Click the Microsoft Office button, click Excel Options, and then click Add-Ins.
  2. Select the Add in type in the Manage box and then click Go.
  3. Clear the check for the ACDManagedAddin.Connect add-in, and then click OK.