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 or by right-clicking and choosing “Paste”)

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.

Troubleshooting: Paste as Grunt

If your data is pasted as a native table, ensure that the "Paste as Grunt" option is enabled in the Grunt-ribbon mceclip0.png.

 

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?
10 out of 14 found this helpful

Comments

2 comments

  • This functionality does not seem to work. When I paste the data from Excel into chart data in a Grunt chart, it does not link to the Excel data - it becomes a static set of data. It does not change when I edit the Excel data, it does not change if I open up Edit Data again, and it does not seem to care if I get rid of the Excel document or not.

     

    I've turned "Paste as Grunt" on.

     

    It does not matter if my source-Excel is saved to a local hard-drive or a Cloud location. It does not matter if I'm pasting data that is a set of static figures in Excel or a set of functions.

    Is this because I'm using a trial version?

    Comment actions Permalink
    0
  • Hi Henrik,

    Please refer to this video for the best approach to link Excel data to a Grunt-chart.

    https://app.grunt.pro/academy/item/7zcom1h8kn0seqf5yb1i

    Hope this helps,
    Mads from the Grunt team

     

    Comment actions Permalink
    0

Please sign in to leave a comment.