Microsoft Office contains functionality to link data from Excel to PowerPoint. It is called OLE (Object Linking and Embedding). Using this technology you can link to Excel charts and ranges in a PowerPoint presentation, in a similar way as OfficeReports Link. When the data in Excel changes, the tables and charts in the presentation can be updated. To edit the linked tables and charts you have to double-click them, which will load Excel’s user interface and you will be able to edit the Excel chart or range from within PowerPoint.
OfficeReports Link works different. It simply uses native PowerPoint tables, charts and shapes, and copies whatever information the user has defined (like data, font, background color) from the defined Excel range to the PowerPoint table, chart or shape.
Therefore, OfficeReports Link has the following advantages over Microsoft OLE:
- OfficeReports Link can link Excel data to native PowerPoint shapes
- Linked charts and tables are ordinary native PowerPoint charts and tables, and can be edited at all time. Even when the linked workbook is not there anymore!
- Charts and tables can be designed in PowerPoint, and linked to Excel afterwards. Using OLE, the charts and tables need to be created by using OLE.
- OfficeReports Link enables ‘conditional formatting’ for native PowerPoint tables, charts and shapes.
- OfficeReports Link can link a specific background color in Excel as an icon in PowerPoint
- OfficeReports Link can link a specific text in Excel as a logo in PowerPoint
For more information about OfficeReports Link, please visit our homepage.