Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Grid to Excell Error
Microsoft Dynamics SL (Archived)

Grid to Excell Error

(0) ShareShare
ReportReport
Posted on by Steve Wier 940

I have one workstation that has problems with the "Grid to Excel" functionality in Quick Query AND SL Screens.  Since the grid to excel functionality was working fine up until a few weeks ago, I suspect a Office Service Pack or a Windows update caused the issue.  However, I have been unable to identify the source.  I tried uninstall/reinstall of SL, uninstall/reinstall of Office without success.  Any other suggestions would be appreciated.

 Details:

 Windows 7-32 bit
Office 2010 Pro Plus
SL 8.00.20320.00

 Thank you!

Steve

*This post is locked for comments

  • Suggested answer
    Steve Wier Profile Picture
    Steve Wier 940 on at
    RE: Grid to Excell Error

    I ran into this issue again with Office 2016 and any SL screen using the grid to excel function.  The fix was to disable the "Adobe Contribute Plugin" COM Add-In.    8461.Capture.PNG

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Grid to Excell Error

    No Sure if it will help others, but we recently had this issue where Grid to Excel was not functioning.  The issue was 64-bit Office.  We uninstalled that Office and reinstalled 32-bit Office and the Grid to Excel functionality works again.  Our Windows is 32-bit.

  • Stuart Stephens Profile Picture
    Stuart Stephens 160 on at
    RE: Grid to Excell Error

    I had this problem with a user who got a new laptop (Windows 7 / Office 2013). It turned out the root cause was the Avery COM Add-in (NOT an Excel Add-in). From the screen shot above, one has to choose the "Com Add-ins" from the drop down at the bottom center of the screen and then "Go" to get a different window to manage the COM Add-ins.

    I suspect this shipped with the laptop as I was not aware that the user had any unusual software installed.

    Regards,

    Stuart

  • Afuentes Profile Picture
    Afuentes 3 on at
    RE: Grid to Excell Error

    Hi everyone,

    We still have this problem. We have Windows 7 on 64 bits and Office 2010 on 32 bits. Would that be the problem?

    Thanks in adavace,

    Angel

  • Steve Wier Profile Picture
    Steve Wier 940 on at
    RE: Grid to Excell Error

    Make sure that excel has all the add-ins turned off/inactive.  I have found a number of add-ins that cuase this error to occur and were fixed by simply disabling the add-in.  The one that comes to mind is the Avery label add-in.

     

  • Afuentes Profile Picture
    Afuentes 3 on at
    RE: Grid to Excell Error

    Thanks Rachel,

    We completed the process that you mention in the last post, but the functionality still not working. Any other ideas?

    Regards,

    The version of Microsoft office is 'office professional plus 2010' v14.0.6129.5000 (32 bits)

  • Rachel Moore Profile Picture
    Rachel Moore on at
    RE: Grid to Excell Error

    Angel,

    Have you tried an uninstall and renistall of SL/Office? If not, please do so in the following order:

    - Uninstall Office, reboot

    - Uninstall SL client, reboot

    - Reinstall office, reboot

    - Apply an MS Office updates, reboot

    - Install SL Client

    You will also want to be sure that the version of Office installed is compatible with the version of SL that is installed. Microsoft Dynamics SL 2011 requires Microsoft Office 2010.

  • Afuentes Profile Picture
    Afuentes 3 on at
    RE: Grid to Excell Error

    Hi,

    Are there any other suggestions about this problem? we applied the HF and rename the XLStart folder, but the functionality to export to excel still not working.

    thanks

    Angel

  • Steve Wier Profile Picture
    Steve Wier 940 on at
    Re: Grid to Excell Error

    I did find a resolution to this issue. Simply rename the XLStart folder in the users profile to XLStart.old

    C:\Users\Username\AppData\Roaming\Microsoft\XLStart  

    Restart Excel and then close Excel.  Quick Query will now export to excel without error.

  • Rachel Moore Profile Picture
    Rachel Moore on at
    Re: Grid to Excell Error

    Hello Steve,

    I was wondering if you were still experiencing the issue.

    If there's anything further I can help you with, please let me know.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,602 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,340 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans