Export to MSExcel 2007

[sabine8]

hi,
i need to know how to export reports to MS Excel 2007 because when i click on export, i can't see the 2007 version in the list, i only see 97-2000. But the problem is that the older versions are .xls and the 2007 one is .xlsx so how can i make it export to 2007?

 

[groggle]

According the "Supported Platforms" document that comes with BOE XI R2 SP2, Office 2007 support is as follows:

BusinessObjects Enterprise XI Release 2 SP2 for Windows Supported Platforms
• Windows Office XP SP3
• Windows Office 2007*
* Office 2007 support is for Business Objects Live Office and as an export destination for Crystal Reports.

I have SP2 installed but cannot see an additional export item on the list inside of CR XI R2. Maybe it means the .xls format can be opened by Excel 2007?

 

[groggle]

Yes SP2 allows the Export to Excel from Crystal Reports to be read by Excel 2007.

It also provides "Live Office" connectivity from Excel 2007 to Business Objects report objects.

 

[sabine8]

1-How can i see it in the list?
2-Do u think if i export it to .csv file and then open it with Excel 2007, it will work?
Thanks

 

[groggle]

A Business Objects sage advised me that you don't see it in the list of export options, it means that the xls file that is exported by an SP2 installation of CRXI can be read by Excel 2007.

The csv option should work.

 

[sabine8]

ok thanks a lot!