The OfficeReports 'Link' menu in PowerPoint
The OfficeReports 'Link' menu in PowerPoint

Connectors

  • Link to an Excel Workbook

  • Link to a database (SQL)

  • Link to an API (JSON)

  • Connect to a datasource using 'R'

Link data to a Table

Link data to a Table
  • Link to multiple ranges

  • A range may contain empty rows and empty columns

  • The size of the range is variable

  • The size of the table is variable

  • Replace texts by logo images

  • Show background color of linked range (conditional formatting!)

  • Translate background color of linked range into an icon

  • Automatically run a VBA macro

Link data to a Chart

Link data to a Chart
  • Link a range to a chart

  • The range may contain empty rows and empty columns

  • The size of the range is variable

  • Replace texts by logo images

  • Show background color of linked range (conditional formatting!)

  • Translate background color of linked range into an icon

  • Automatically run a VBA macro

Link data to a Shape

Link data to a Shape
  • Link a range to a shape

  • Replace texts by logo images
  • Show background color of linked range (conditional formatting!)

  • Automatically run a VBA macro

Collaborate

Collaborate
  • Just email the files to colleagues. It will work.

Reuse the report definition

Reuse the report definition
  • Link to a different datasource/workbook, and all tables , charts and shapes will be updated