insert excel worksheet - desparate...

milanese

unread,

Dec 29, 2009, 5:01:01 AM12/29/09

to

hi guys,

having a problem currently, when I try to insert a worksheet into ppt.
I have a excel multi-worksheet ( 5 sheets ) and each of them has 1000 by
1000 fields.
so, I am able to insert an icon with the link to the existing ppt. which
does not appear in running presentation-mode.
and second that I tried is to copy the worksheet into my slide! but the
problem is: I can not scroll left-right - up - down. this copy paste seams to
be like a screenshot which scrolled, selected etc... when presentation is
running.

so maybe somebody can help me with this:
is it possible to insert excel worksheets with slide bars (horizontal and
vertical)
which can be selected and moved during the presentation without exit of this
ppt-mode.

thx in Advance guys....

Echo S

unread,

Dec 29, 2009, 12:02:30 PM12/29/09

to

You'll need to add an object action animation. Which version of PPT are you
using?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx

"milanese" <mila...@discussions.microsoft.com> wrote in message
news:D743FF79-73E7-4D14...@microsoft.com...

milanese

unread,

Dec 30, 2009, 2:15:01 AM12/30/09

to

I use powerpoint 2007.
object action animation. realy?

I also tried with using textbox it that I copy my excel-cells, and in the
propoties tab I set the scrolbar for this textbox, but this solution does not
satisfy me realy, cause it is just a text and all the spaces and formatting
gets lost...

any idea?
thx for help....

"Echo S" wrote:

> .
>

Echo S

unread,

Dec 30, 2009, 8:38:57 PM12/30/09

to

Thanks.

Select the cells, then Paste Special (Home | Paste | Paste Special) and
choose the first option -- MS Excel Workbook Object. (You can also use
Insert | Object for this if you want.)

Select the Excel object on the slide, then go to Animations and click Custom
Animations to open the Animations Pane.

In the Animation Pane, choose Add Effect | Object Action s| Edit (or Open --
I think it doesn't matter in this example).

Double-click the Object animation in the Animation Pane and go to the Timing
tab. Choose Triggers | Start Effect on Click Of. In the dropdown, choose the
Excel Object -- it's the same name as it is on the Custom Animation tab,
probably Object 1 or similar.

Now run it in Slide Show View. Excel will open when you click the worksheet
object on the slide.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx

"milanese" <mila...@discussions.microsoft.com> wrote in message

news:18B268AD-A3AB-40E0...@microsoft.com...