Linking to data from Excel

To insert a new Visual Grid with data linked to an Excel file, follow the outline below:

  1. Open the Excel file
  2. Copy the range you want to link to (either by pressing Ctrl + C or by right-clicking and choosing “Copy”)
  3. Go to the PowerPoint slide where you want to insert the Grunt Visual Grid.
  4. Paste the contents of the clipboard (either by pressing Ctrl + V, by right-clicking and choosing “Paste” or by pressing the Paste-button in the Grunt tab in the Ribbon)

The Visual Grid will automatically be created and linked to the range you copied from Excel. The initial number of rows and columns will match the number of rows and columns in the Excel range, however, you can change this later by changing the structure of your Visual Grid.

 

Changing your data

If you get new data, we strongly recommend updating the data directly in the Excel-file. As soon as you save your changes, Grunt will let you know in PowerPoint. You can choose to accept the changes or ignore the warning. Note that if you choose the latter the warning will not be visible in presentation mode or in prints etc. 

2019-06-26_10_54_31-Visual_Grid.pptx_-_PowerPoint.png

If your presentation is connected to an external Excel-file, but you still choose to update your data directly in PowerPoint, these changes will not be pushed back to the Excel-document. However, if you open the Data editor the cells that have been overwritten are marked with a little orange corner mark. 

2019-06-26_10_58_57-Clipboard.png

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.