basic powerpoint courses - Excel how to link to ppt

Resolved · Low Priority · Version Standard

Excel how to link to ppt

Alexandre has attended:
Powerpoint Advanced course

by - delegate Alexandre [1 post] (2007 Nov 30 Fri, 15:28) Reply

I want automatic plotting win ppt when modifying my data base in excel

Version	Date	Location	Places available	Book	Next place rate:
Powerpoint Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£240	£245
2003	2008 Dec 9 Tue	Southwark	4	book now	£224	£235
2007	2008 Dec 16 Tue	Bloomsbury	3	book now	£240	£245
2002/XP	2008 Dec 19 Fri	Tooting	0	FULL
2007	2009 Jan 6 Tue	Bloomsbury	4	book now	£240	£245
2002/XP	2009 Jan 9 Fri	Tooting	0	FULL
Full Schedule: See all 56 Powerpoint Advanced course dates. Bookings currently available until 27th November 2009.

RE: Excel how to link to ppt

by - trainer Amanda diamond contributer [1243 posts] (2007 Nov 30 Fri, 16:51) Reply

Hi Alexandre

Thank you for your question.

You can link an Excel spreadsheet to a PowerPoint file by going to the Insert ribbon, Text group and clicking the Object button. Select Create from file, then browse to where your spreadsheet is and select it. Tick the Link box under where you see the name of the Excel file displayed in the File: box.
Then click OK.

From memory only the data that is stored in the first/top sheet in your Excel file will be imported and linked to, therefore whatever data you want to be linked to the PowerPoint presentation must be displayed in the first/top sheet of the Excel file.

Amanda