Advanced Export lets you fine-tune the aspect of your linked Excel tables in PowerPoint or Word once they’re updated. Tailor each export to its context and spend less time fixing your layouts after updating the source data.
Use the Advanced Export
By default, UpSlide links are exported to PowerPoint or Word to match the original element in Excel as closely as possible. Use Advanced Export when you need more control over the appearance of linked Excel tables.
- Select a range in Excel.
- Click the PowerPoint or Word export button, then click Advanced Export, or use Ctrl+Alt+A.
- Select the required options and click Ok.
Resize to fit the selection
Use this option to resize the exported table to fit a shape or placeholder that you selected in PowerPoint or Word before exporting. UpSlide maintains the table’s proportions while scaling its width to fit the destination placeholder, so you do not need to resize it manually after export.
Preserve cell’s initial visibility
By default, PowerPoint or Word displays the rows and columns that are visible in Excel when you update a linked table. If you later hide, unhide, or add rows or columns within the exported range, those changes are reflected in the linked table.
Enable Preserve cell’s initial visibility to keep the rows and columns that were visible when you exported the table, even if you hide them in Excel later.
For example, you can use one Excel table containing sales figures for all business units and create a separate slide for each unit. Hide the rows that you do not need, export the table with this option enabled, and repeat the process for each unit. Each slide remains linked to the same Excel table while displaying only the relevant data.
Preserve image width in PowerPoint/Word
By default, the width of a linked table changes in PowerPoint or Word when you add columns in Excel to extend the original range. If you exported the table to fit a specific placeholder, enable Preserve image width in PowerPoint/Word to keep the table’s width unchanged when you update it, even if you add new columns in Excel. The ratio is maintained, which can reduce the height and font size.