Linking Multiple Excel Worksheets in a Presentation

Linking Multiple Excel Worksheets in a Presentation - HELP!!!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Denise C - 07 Sep 2007 15:54 GMT

Is there any way to link multiple worksheets into a presentation? I have a
spreadsheet that has 13 worksheets; I need to put each one into my
presentation, linked to the spreadsheet.

When I tried to do this, PowerPoint took whatever sheet was current at the
time I saved and closed the file. I went through and inserted each one,
opening, changing the current sheet, saving and closing the file each time.
Then when I closed the presentation, reopened it and clicked Update Links, it
inserted the current sheet onto all 13 of my slides! HELP!! It seems I may
have to make each a separate file.... what a pain!

Does anyone know a better way?? I need this job done for a customer by
Tuesday, so any help would be greatly appreciated!!

Signature

Denise C

Reply to this Message

Steve Rindsberg - 07 Sep 2007 17:53 GMT

> Is there any way to link multiple worksheets into a presentation? I have a
> spreadsheet that has 13 worksheets; I need to put each one into my
[quoted text clipped - 8 lines]
>
> Does anyone know a better way??

Yep. My guess is that you created the links by using Insert, Object, selecting
the XLS file and choosing Link.

When you do that, PPT has no idea what exactly you want to link to so it
displays whatever's current in the XLS when it updates. If you change the
current view, the next update changes it in PPT also.

Instead, go the other way:

Select your data in Excel
Choose Edit, Copy
Switch to PPT
Choose Edit, Paste Special, Link

Now the link includes a pointer to the worksheet and range you selected, so PPT
will always display just that, no matter what you do in the XLS when editing it
later.

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Reply to this Message

Denise C - 07 Sep 2007 19:10 GMT

Hi Steve! Yep, that's how I did it. THANK YOU so much for your help!! I'm
heading back to Excel and PowerPoint now to make the changes. Have a blessed
weekend, and THANKS AGAIN!

Signature

Denise C

> > Is there any way to link multiple worksheets into a presentation? I have a
> > spreadsheet that has 13 worksheets; I need to put each one into my
[quoted text clipped - 32 lines]
> PPTools: www.pptools.com
> ================================================

Reply to this Message

David M Wicker - 18 Sep 2007 23:10 GMT

>Hi Steve! Yep, that's how I did it. THANK YOU so much for your help!! I'm
>heading back to Excel and PowerPoint now to make the changes. Have a blessed
[quoted text clipped - 36 lines]
>> PPTools: www.pptools.com
>> ================================================

I've got a situation where I've got a global roaming manager that
wants to have his complete ppt with him, and doesn't want to have the
excel files travelling as well
currently, we cut and past from 6 speadsheets to make up his monthly
ppt pack
any suggestions?

Reply to this Message

Steve Rindsberg - 19 Sep 2007 02:42 GMT

> I've got a situation where I've got a global roaming manager that
> wants to have his complete ppt with him, and doesn't want to have the
> excel files travelling as well
> currently, we cut and past from 6 speadsheets to make up his monthly
> ppt pack
> any suggestions?

Keep doing the same thing, I suppose? Or combine the spreadsheets so you don't have
to work with so many of them.

Or, if he doesn't need to be able to edit the Excel data, just link then set the
links to manual update. Effectively that gives you a picture of the Excel data but
it doesn't require that the XLS files be present.

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Reply to this Message