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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
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??
Click to expand...

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.
 
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!
 
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!
Click to expand...

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?
 
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?
Click to expand...

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.
 
Back
Top