Inserting an Excel worksheet into a Powerpoint slide

[w***@officeformac.com]

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!

[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

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!

[w***@officeformac.com]

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.

[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

Post by w***@officeformac.com
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.

[D***@officeformac.com]

wreidel and CyberTaz, <br>
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 &quot;live&quot; you can click it and get to a _copy_ of the original Excel which now has a name something like &quot;worksheet in [filename of PPT file].&quot; 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 &quot;edit/paste/specail&quot; 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. <br><br>This does _not_ seem to work if you start by inserting an excel object directly from PPT. You have to start in Excel. <br><br>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: <br><br> 1) Error message says: MS Excel cannot save autoresotre info to Macintoch HD: users: [etc pathname continues]: microsoft user data: office 2008 autorecovery. <br><br>2) While 1) was happening, Powerpoint said: &quot;This action cannot be completed because the app MS Excel is busy. Click &quot;Switch To&quot; and correct the problem. &quot; [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. <br><br>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 &quot;The server application, source file or item cannot be found...check path...or try reinstalling....&quot; After force quitting and trying again, the file opened correctly.... <br><br>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....

[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>

Post by D***@officeformac.com

Post by CyberTaz
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.

<snip>
______________________________

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

Post by D***@officeformac.com
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.
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....

[w***@officeformac.com]

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***@officeformac.com]

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!! <br><br>Glad it worked for you! <br><br>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 &quot;no more&quot;)