Error Exporting to Excel from Business Portal 5.1 for Microsoft Dynamics GP 2010 in Internet Explorer 9

If you're using Business Portal 5.1 for Microsoft Dynamics GP 2010 along with Internet Explorer 9 and attempt to export the results of a query to Excel you may have received the following "Results not copied to Excel" error:

 

This generally happens when the result set you are exporting is large (~1000 records or greater).

When exporting a Business Portal query to Excel we utilize a java script file in your Business Portal installation folder. We have worked with our development team to come up with a fix for this issue.

This workaround involves modifying the DataCenter.js file that is found in the C:\Program Files\Microsoft Dynamics\BusinessPortal\Portal\Datacenter directory on your Business Portal server. The steps are as follows:

1)      First, make a backup of DataCenter.js

2)      Then, open DataCenter.js in Notepad

3)      Search this file for "//Size it"

4)      Edit the file as follows to add the alert section:

Before Edit:

                }

                                }

                                //Size it

                                if(excel.MajorVersion < 10) {

                                                excel.ActiveSheet.UsedRange.AutoFitColumns();

                                                excel.ActiveSheet.UsedRange.AutoFitRows();

                                }

 

After Edit:

 

           }

                                  alert("Click to export");

                                 }

                                 //Size it

                                if(excel.MajorVersion < 10) {

                                                excel.ActiveSheet.UsedRange.AutoFitColumns();

                                                excel.ActiveSheet.UsedRange.AutoFitRows();

                                }

 

NOTE: You can change the text in the alert() line to whatever you'd like.

5) Save your changes to this file

6) Reload Business Portal and export a query to Excel. You should now receive the alert prompt, which will give the site the short amount of extra time it needs to successfully export to Excel.

NOTE: You may find that you need to run IISRESET before this change will take effect.

Implementing this quick fix should allow you to successfully export your Business Portal query data to Excel after you have upgraded to IE9.

Enjoy!

Lucas