With SAP BusinessObjects Live Office it is possible to insert data from Crystal Reports and Web Intelligence reports into the Microsoft Office products (Word, Excel, Outlook, PowerPoint). As the data can also be refreshed with this add-on, the Live Office Connection can be a very useful way to provide our dashboards with fresh data.
For this recipe, you need a SAP BusinessObjects Enterprise installation and the Live Office Connection software installed on your client computer. You need a Crystal Report, Web Intelligence report, or Universe (to connect to) as well.
Open a new Dashboard Design file and go to the Preferences in the File menu. In the Excel Options section, check if Live Office Compatibility is enabled.
Go to the Live Office tab of the spreadsheet. Click on the Crystal Reports or Web Intelligence button to insert a report.
Log on to your SAP BusinessObjects Enterprise environment and choose a report.
If your report contains...