I have an Excel Spreadsheet that has about 150 rows and want to embed it into
PowerPoint. Do I need to manually divide the spreadsheet so it will cover 2
or 3 slides?

Signature
Judy
milind.nakadi@gmail.com - 31 Aug 2006 00:53 GMT
I have excel spreadsheet whic contains data as well as charts I want to
conver same worksheert into powerpoint with the help of VBA code.
can anyone help me in the same...?
will help me a lot in my work...
Regards
Charu
> I have an Excel Spreadsheet that has about 150 rows and want to embed it into
> PowerPoint. Do I need to manually divide the spreadsheet so it will cover 2
> or 3 slides?
Echo S - 31 Aug 2006 17:01 GMT
>I have an Excel Spreadsheet that has about 150 rows and want to embed it
>into
> PowerPoint. Do I need to manually divide the spreadsheet so it will cover
> 2
> or 3 slides?
Yes. PPT doesn't have a "span slides" option.
You might check http://www.pptfaq.com/FAQ00068.htm -- you may be able to
paste the spreadsheet onto a slide and then divide it up in PPT.
Or you may be better off copying the appropriate cells in Excel and using
Edit|Paste Special and choosing WMF or EMF to past a picture of the
spreadsheet. Just depends on your needs.

Signature
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com
Judy - 31 Aug 2006 17:16 GMT
Thank you very much; I appreciate your response. It was quite laborious
searching for an answer. I did, however, learn several new tips.

Signature
Judy
> >I have an Excel Spreadsheet that has about 150 rows and want to embed it
> >into
[quoted text clipped - 10 lines]
> Edit|Paste Special and choosing WMF or EMF to past a picture of the
> spreadsheet. Just depends on your needs.
Echo S - 31 Aug 2006 18:52 GMT
I'm sorry it was hard to find an answer, but I appreciate you putting in the
effort to search -- and I'm glad you came across some useful information in
the process! (I suspect this exact question hasn't been asked before, so
that probably made it even more difficult than it might have been.)

Signature
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com
> Thank you very much; I appreciate your response. It was quite laborious
> searching for an answer. I did, however, learn several new tips.
[quoted text clipped - 14 lines]
>> Edit|Paste Special and choosing WMF or EMF to past a picture of the
>> spreadsheet. Just depends on your needs.
Austin Myers - 31 Aug 2006 17:18 GMT
I just have to ask... <g>
Do you really think your audiance wants/needs or will bother with reading
150 rows of numbers? Not to be cruel but I can't think of anything that
would put me to sleep faster.
$.02 worth
Austin Myers
MS PowerPoint MVP Team
Provider of PFCMedia http://www.pfcmedia.com
>I have an Excel Spreadsheet that has about 150 rows and want to embed it
>into
> PowerPoint. Do I need to manually divide the spreadsheet so it will cover
> 2
> or 3 slides?
Steve Rindsberg - 31 Aug 2006 22:49 GMT
> I just have to ask... <g>
>
> Do you really think your audiance wants/needs or will bother with reading
> 150 rows of numbers? Not to be cruel but I can't think of anything that
> would put me to sleep faster.
Haven't done many presentations before accountants, finance people and boards
of directors, eh? <g>
Sometimes they really do scrutinize all that (on printout, one hopes, since
nobody'd be able to read it on screen). And sometimes it needs to be there in
case anybody asks about the details. Or so that six months later you can say,
with a straight face, "But it was in the presentation you saw last June. Slide
14. Don't you remember?" ;-)
(Can you tell I've fought the good fight but the other guys won?)
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Steve Rindsberg - 31 Aug 2006 19:29 GMT
> I have an Excel Spreadsheet that has about 150 rows and want to embed it into
> PowerPoint. Do I need to manually divide the spreadsheet so it will cover 2
> or 3 slides?
Not exactly, but sort of.
Select a section at a time in Excel then copy/paste into PPT.
Or maybe that's what you meant, in which case, ... Yes. Exactly! ;-)
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Brian Reilly, MVP - 05 Sep 2006 16:36 GMT
Hi Judy,
I see my good friends Echo, Steve and Austin have given you the right
normal answers. Here's another. Copy and paste the important part of
the spreadsheet into PPT and attach a hyperlink to the actual
spreadsheet if people really want to see it all. It'd be easier to
read and scroll around in Excel if you need to.
Brian Reilly, MVP
>I have an Excel Spreadsheet that has about 150 rows and want to embed it into
>PowerPoint. Do I need to manually divide the spreadsheet so it will cover 2
>or 3 slides?