Inserting an Excel worksheet into a Powerpoint slide


W

wrseidel

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel In Windows Power point 2004 inserting an Excel spreadsheet into a power point slide was a simple matter of clicking on the icon in the power point toolbar and then creating the new worksheet. You could simply manage what showed on the slide by scrolling the desired worksheet cells into screen view. None of this can I find in Powerpoint for Mac 2008. I love the chart and table insert functions but where did Excel go? I'm lost. HELP!
 
Ad

Advertisements

C

CyberTaz

No, there is no handy button on the bar nor is there an explicit command
that enables adding the feature as a button. However, if you go to Insert>
Object, Microsoft Excel Sheet is among the choices.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
W

wrseidel

Outstanding! Thanks. Now I can insert the worksheet but how do I control what cells are shown in the final slide? In the PC 2004 version you could scroll and shrink the worksheet to show only the cells you wanted. I can't find the same capability in power point for Mac 2008.
 
C

CyberTaz

I was afraid you'd come back with something like that :)

Unfortunately, that isn't an option. Linking in the Mac version of PPT is
quite restricted compared to the Windows version ‹ Something many of us have
been complaining about for years. Hopefully the next release will improve,
but in the meantime you're stuck with having to use the top left corner of
the sheet... And since you'll also return to ask :) Only the first 6
columns by first 20 rows will display on the slide.

For larger volumes of content or content elsewhere in an existing Excel file
you can copy/paste, but there's no Link option if you do so.

Regards |:>)
Bob Jones
[MVP] Office:Mac
 
W

wrseidel

This does work! I tried it with a much larger spreadsheet and in Excel and did as you recommend by cutting and pasting to PPT. Thanks for the tip!!
 
D

DCP59

This does work! I tried it with a much larger spreadsheet and in Excel and did as you recommend by cutting and pasting to PPT. Thanks for the tip!!

Glad it worked for you!

Please do post if you run into the crash/hang issues when pasting Excel cells and Excel Charts into PPT. They are very frustrating, and yes all software from Apple and MS is fully updated (ran updates until they said "no more")
 
Ad

Advertisements

C

CyberTaz

I'm glad the OP got what s/he needed & I really don't care _who_ gets credit
for the solution, but isn't this just an overly complicated, much longer
iteration of what I suggested in the final paragraph of my last message?:
______________________________

<snip>
______________________________

Regards |:>)
Bob Jones
[MVP] Office:Mac



wreidel and CyberTaz,
Try this, it's not fully what you are looking for, but closer. Open Excel and
build a small sheet, 2 apples plus 3 pears equals total fruit. Copy the cells
(command C or edit/copy) and then move to Powerpoint. Click Edit/paste
special and choose to paste Microsoft Excel Sheet Object. It will be placed
in PPT slide and it will be "live" you can click it and get to a _copy_ of the
original Excel which now has a name something like "worksheet in [filename of
PPT file]." You will see that this embedded (I think) excel sheet is full
size and you can use all of it. If you want to have another section appear in
the PPT, you can copy it and again "edit/paste/specail" and the new section
will be live in the PPT. I think there is a size limit on # cells but you can
get different sections in the slide and the underlying sheet is full size and
live. The underlying excel sheet in the PPT is _not_ linked back to the
original exel, but it is live and you can work in it.

This does _not_ seem to work if you start by inserting an excel object
directly from PPT. You have to start in Excel.

Hope this is helpful. A caveat: After playing with above for a bit, I got
following three errors over a few mintues which may be related. If you have
any insights into these, much appreciated as I am brand new to MAC and Office
2008. I have fully updated OSX snow leopard and fully updated Office 2008.
Errors:

1) Error message says: MS Excel cannot save autoresotre info to Macintoch
HD: users: [etc pathname continues]: microsoft user data: office 2008
autorecovery.

2) While 1) was happening, Powerpoint said: "This action cannot be completed
because the app MS Excel is busy. Click "Switch To" and correct the problem.
" [The problem was #1 and after several tries clicking all options (OK or Do
not show this dialog again) I ended up having to force quit excel as it was
fully hung.

3) FIve minutes later I tried opening one of the very small excel files I'd
been playing with and it hung on trying to open--I got spinning rainbow and
had to force quit. Then got message "The server application, source file or
item cannot be found...check path...or try reinstalling...." After force
quitting and trying again, the file opened correctly....

Anyway, try the above and see if it gets you closer to what you want. I am
brand new to MAC and just figuring out some of the frustations of Office
2008....
 

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