Link excel file to slide

The UK's most regular instructor-led training courses.
Training information: advanced power point · Powerpoint training · Microsoft PowerPoint Training London
See also · powerpoint training · powerpoint.course · powerpoint advanced

Resolved · Low Priority · Version 2007

1 post

ReplyMon 12 Oct 2009, 16:27Delegate Heather said...

Heather has attended:
Powerpoint Intermediate Advanced course

Link excel file to slide

I would like to link only a certain sheet in an excel file to the slide, I do not want anyone to be able to see other sheets in the excel file, is it possible to do it?

Version	Date	Location	Places available	Book	Next place rate (£)
Powerpoint Intermediate Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Fri 26 Mar 2010	Bloomsbury	3		£235	£240
2003	Fri 26 Mar 2010	Southwark	0	FULL
2003	Mon 29 Mar 2010	Bloomsbury	3		£235	£240
2007	Thu 1 Apr 2010	Limehouse	4		£224	£225
2007	Tue 13 Apr 2010	Bloomsbury	9		£182	£187
2007	Fri 16 Apr 2010	Limehouse	6		£212	£217
Full Schedule: See all 28 Powerpoint Intermediate Advanced course dates. Bookings currently available until 16th December 2010.

2,024 posts

ReplyTue 13 Oct 2009, 09:39Trainer Amanda said...

RE: link excel file to slide

Hello Heather

Thank you for your question and welcome to the forum.

A link to an Excel file in PowerPoint will open the whole Excel file, so if you don't want people to be able to see the other sheets in the file it might be best to make a copy of the specific sheet you want them to see; and put this in another workbook.

You can do this quickly by right-clicking on the tab of the sheet in the Excel file, and selecting the Move or Copy option. Select the sheet to copy; select New book from the To book dropdown; tick the Create a copy box and click OK.

Kind regards
Amanda

Mon 19 Oct 2009: Automatically marked as resolved.

· Alternative ways to use Power Point software (Part 1)
· Personal Experiences of a PowerPoint Presenter Living in London
· PowerPoint Advanced Concepts: The Importance of Design
· PowerPoint: Presenting in Colour
· The Magic Of Hyperlinks In PowerPoint 2003

Please browse our web site to find out more about
advanced power point and other Microsoft training courses.

Powerpoint tip:

Ways to make exact copies of shapes

There are several ways of making exact copies (duplicates) of shapes you have already drawn in PowerPoint:

1. Use Copy and Paste.

2. Select the shape you wish to duplicate and use Ctrl + D.

3. Select the shape to be duplicated, then hold down the Ctrl key while you drag to the position where you want the duplicate shape to appear.

View all Powerpoint hints and tips