LINK TO EXCEL TABLE

<< Click to Display Table of Contents >>

Navigation:  Text Tables >

LINK TO EXCEL TABLE

Previous pageReturn to chapter overviewNext page

Once you have linked to an Excel table, you can manually refresh the link if the data in Excel changes.

REFRESH LINK TO EXCEL:

Mekko Graphics allows you to manually refresh an established link to Excel. When you refresh your link, the data in Microsoft Excel™ will re-populate the referenced data table. Therefore, any changes to the data in your Excel range will be reflected in table in PowerPoint. The Refresh option is only enabled if there is an established link. If there is no link, the Refresh button is disabled.

The refresh can be for one table or can be initiated for all tables in your slide deck through the Excel Link Manager.

 

TO REFRESH A TABLE IN POWERPOINT:

From the Excel Link Manager, click the Refresh icon in the row representing the table you wish to update. You can also right click the table and click Refresh.

Note: Auto Refresh functionality is not available for tables, as it is with charts.

 

TO REFRESH ALL LINKED TABLES:

To refresh all linked tables in a presentation, open the Excel Link Manager and choose Refresh All Table Links.

 

TO REMOVE A LINK TO EXCEL:

You may remove any established table links to Microsoft Excel™ from Mekko Graphics. The Remove option is only enabled if there is already an established link.  It is not enabled if there is no link.  Removing a link simply removes the reference to Excel; it does not remove the data.  

 

HOW TO OPEN A LINKED FILE:

Mekko Graphics allows you to open the linked table in Microsoft Excel™. From the Edit Chart toolbar, choose Link to Excel --> Open Linked File.