Using Live Office Connection

With SAP BusinessObjects Live Office it is possible to insert data from Crystal Reports documents and Web Intelligence reports into Microsoft Office products (Word, Excel, Outlook, PowerPoint). Since 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.

Getting ready

For this recipe you will need SAP BusinessObjects BI Platform to be installed on your machine and the Live Office Connection software installed on your client computer. You will also need a Crystal Reports document, a Web Intelligence report, or a Universe to connect to.

How to do it...

1. Open a new SAP BusinessObjects Dashboards file and go to Preferences... in the File menu. In the Excel Options section, check if Live Office Compatibility is enabled.

   

   Note

   For better tool stability, only enable this option when you are actually using Live Office in your dashboard.

2. Go to the Live Office tab of the spreadsheet. Click the...