The Excel Link Manager (ELM) allows you to update multiple Excel Links at once through a single pane. If you are used to the Update All window, the difference is an improved and more user-friendly navigation pane, where you can group links by slide or Excel sources or filter only those links with update issues.

Activating the Excel Link Manager

If you are on version 6.8.42 or higher, you can follow the below instructions. You can check which version you're using by going into the UpSlide Settings in the tab About.

If you do not have the option to activate it, you are on an older version of UpSlide and should contact your IT or admin to check when you will be upgraded:

1. Open the Update All window in PowerPoint
2. Toggle Try the Excel Link Manager at the bottom of the window

How to navigate the Excel Link Manager

Thanks to the Excel Link Manager, save time updating multiple links at once. If you are looking at updating a single link we recommend that you follow these steps.

The Excel Link Manager will enable you to:

• View and navigate links grouped by slide and workbook/sheets.
• Update multiple links at once (e.g. all links sharing the same Excel source, all links in a slide, or all links in a presentation).
• View problematic links grouped by issue type (no source, multiple sources or outdated content).

Please be aware that the option to Include all open documents when updating Excel Links is no longer available in the Excel Link Manager.

How to update Excel Link items

Use Slides view to update links

The Slides view helps you sort your Excel links in order as they appear in your presentation, and you can select the slides you want to update. Expand each slide to see all available links and press on an individual link, and UpSlide will highlight it for you in your presentation.

To update specific slides simply:

1. Check the tick box for each slide you want to update.
2. Press Update at the bottom right-hand corner.
3. If UpSlide shows issues in updated links, see below steps on how to resolve issues using the ELM quickly.

Use Sources view to update links

In this view, you will see all workbooks linked to your report in alphabetical order. Expand each workbook to reveal all worksheets that have data exported to your current presentation. For more details on where a workbook is saved, hover over a workbook name.

To update data from a specific source, follow these steps:

1. From the list, select the workbook or worksheet you want to update by checking the tick box for each source you want to update.
2. Press Update at the bottom right-hand corner.
3. If UpSlide shows issues in updated links, see below steps on how to resolve issues using ELM quickly.

Managing Excel Link issues from the ELM

There is now a dedicated area to solve Excel Link issues and in this section, you will learn how to resolve different issue types individually. Learn more on why you are getting a warning when updating your data here.

UpSlide will highlight any issues with a danger sign. Follow these steps to fix them:

1. Click on the See all issues button at the bottom right corner to see all warning types.
2. Expand each warning category to reveal links with issues.
3. Click on the Fix button next to the linked item.
4. Select the workbook you want to use for the update from the Potential sources among open workbooks section.
5. Press Update at the bottom right-hand corner.