Advanced Export gives you the choice to preserve cells' current visibility or/and preserve image width in PowerPoint/Word when updating:
Preserve cells’ current visibility
Ever used the Link to export a table with hidden rows or columns? It can be a pain having to remember to re-hide those, whenever you need to update the linked table in your PowerPoint or Word file.
For this reason, we’ve added a new option allowing you to preserve the cell visibility settings of your linked tables! From now on, if you choose to select this option when exporting your table, subsequently unhiding those rows or columns in your linked Excel table won’t change what’s visible in PowerPoint/Word – even when you hit ‘update’.
This means that you can now link one table, multiple times to one or more documents, each time applying a different filter or hiding different rows or columns.
Do you have one table displaying all of your global sales figures, but need to create a separate sales report for each business unit? No problem! Simply hide the irrelevant columns or rows so you’re only displaying the figures you need, and select ‘preserve current cells’ visibility’ when exporting to your presentation. Repeat the same process for each business unit, as many times as you need to! As you can see in this diagram, this will save you lots of time when it comes to reporting:
Here’s how you can use this feature:
- Edit which columns/rows you want visible
- Select the table
- Click on Advanced Export (right next to your usual ‘Export to PowerPoint/Word’ buttons on your UpSlide ribbon in Excel
- Toggle the new Preserve current cells visibility button in the Advanced Export pop-up
- Click “Ok” and your table will be exported
- The cell visibility from your initial Link will be preserved when you update, even if you change cell visibility in Excel!
Preserve image width in PowerPoint/Word
As you know, using the UpSlide Link preserves the width of your linked table or chart when you update it, but what about when you’ve added more columns since you initially exported them? Having the image width being preserved can cause the text in these tables to shrink when you hit ‘update’, which will render your table no longer compliant with your brand guidelines (not to mention being hard to read!).
Thanks to our final new Link function, this will no longer be an issue; you can now decide whether or not you want the width of your linked tables to be preserved when you update them in PowerPoint or Word. If you chose not to, your tables will expand beyond the original placeholder width to prevent your text shrinking. Just make sure you have space in your presentation for the linked image to expand to the right!
See for yourself:
To take advantage of this feature:
- Select the table you want to export
- Click on Advanced Export
- Toggle the new Preserve width in Powerpoint/Word button in the Advanced Export pop-up
- Click Ok and your table will be exported
- If you’ve switched off the Preserve width function, any subsequent update will also update the width of your table if you have increased its size (and thus preserve the font size of your text)!