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.
Windows 7-32 bitOffice 2010 Pro PlusSL 8.00.20320.00
I was able to locate a hotfix for the error you are seeing.
To obtain this hotfix, If you golog into Customer Source then go to Downloads and Updates --> Hotfixes. Locate the list of hotfixes available for SL 2011 and download the hotfix pertaining to bug 23280. The knowledge base article ID is 2552261.
Please let me know if you have any further questions.
RachelTechnical Support Engineer**This posting is provided "AS IS" with no warranties and confers no rights.
I was wondering if you were still experiencing the issue.
If there's anything further I can help you with, please let me know.
I did find a resolution to this issue. Simply rename the XLStart folder in the users profile to XLStart.old
Restart Excel and then close Excel. Quick Query will now export to excel without error.
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.
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.
We completed the process that you mention in the last post, but the functionality still not working. Any other ideas?
The version of Microsoft office is 'office professional plus 2010' v14.0.6129.5000 (32 bits)
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.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13