insert excel worksheet - desparate...

M

milanese

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....
 
M

milanese

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 said:
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 said:
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....

.
 
E

Echo S

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 said:
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 said:
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 said:
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....

.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top