Skip to content

Link data between Excel and Word or PowerPoint

August 3, 2016

If you are doing a presentation – either PowerPoint or Word – and are obtaining data from a spreadsheet, you can literally link the data so that changes in the spreadsheet will appear in the document.

You use paste link feature which is in PPT and Word – on the home tab, click on the drop down arrow under paste, choose paste special, select link on the radio button that appears.  Future edits in Excel will appear in the other document – if it does not appear, right click in the image and select Update Link.  Video below demonstrates this.

Advertisements

From → Excel, PowerPoint, Word

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: