Linking Excel to PowerPoint

cyoose

New Member
Joined
Jul 24, 2002
Messages
24
Is there a way to have Power Point linked directly to Excel? For example, when data is entered in Excel that it would automatically update the related charts in Power Point? I know that the charts can be set up in Excel and then copied/pasted into Power Point, but curious if this could be done.

Thanks for your help!
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

struf

Board Regular
Joined
Jul 2, 2002
Messages
107
click on File-Paste Special-Paste link when you are in Powerpoint.
caution and an FYI; if your graph gets too complex (large), your readers may not be able to open it. In that case, instead of paste link, do a copy and a paste picture.
this will paste only the the graph itself and not all the happy formulas, links, etc that take up a lot of space

have a good day----------

struf
 

Damon Ostrander

MrExcel MVP
Joined
Feb 17, 2002
Messages
4,239
Hi cyoose,

In order to have a worksheet (range of cells) that you paste into PowerPoint be linked you must do a Edit > Paste Special and select As: Microsoft Worksheet Object, and select the Paste Link option button. Then when you edit the worksheet the change will immediately appear in PowerPoint.

It is also possible to write data to PowerPoint from Excel via VBA macro, and this permits writing data, for example, directly into a PowerPoint textbox, table, or even into properties such as slide timings, etc. This is done via Automation.
 

Forum statistics

Threads
1,144,122
Messages
5,722,604
Members
422,447
Latest member
knopp

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top