Exports to Excel in Dynamics BP using Office 2010

Goal 

You are running BP for Dynamics SL or GP on SharePoint 2007.  Your organization is deploying Office 2010 and Windows 7. You want to export to Excel from Query Web Parts. You find issues with BP exports and Office 2010.   

Environment

Dynamics BP for GP 10 or 2011 or Dynamics BP for SL 7.0 or 2011. SharePoint 2007, WCC or MOSS. Workstation is Windows 7 and Office 2010.

Issue

            Trying to export from web parts to Excel generates the following error:

“The Office Web Components OWC must be installed to copy results to Excel”

You lookup OWC and to your dismay you find that Microsoft  stopped supporting this technology. There is not a OWC for Office 2007 or Office 2010.

You can export using this method from two different places:

1)      The Query Web Part shown below:

2)      A Rich List Viewer Web Part as Below:

Resolution

If you lookup this issue on Partnersource, you find that it suggests for Office 2007 to install 2003 and XP Components (10 and 11) until one works.

For Office 2010 on Windows 7 I have found you just need to install 10 (XP Components). Microsoft did not seem to mention Office 2010 (see related articles) 

Download Office XP Tools: Web Components. This is OWC10.exe.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=982b0359-0a86-4fb2-a7ee-5f3a499515dd&displaylang=en

install on Windows 7 and export of data from Query Web Parts in BP will work to Excel 2010.

Conclusion 

Even though OWC is not supported anymore you can still support this technology under Office 2010 and Windows Seven by installing Office XP Tools: Web Components OWC 10.