Pasting Excel - Limited Rows

[CvT]

Hi,
I posted this before but no reply.

I am using Office 2004.

If I paste a table into a slide larger than 39 rows and 16 columns, then
only 39x16 is shown. Interestingly, the full object size is shown.

To make it clearer.. Say I chose an area of 50R x 27C, the object will look
like that size but only 39R x 16C will be viewable but it will look cropped.

This happens if you try to paste the object as a picture too!!

Any work arounds?

 

[CvT]

Hi,
Does anyone have any ideas on this??? I am desperate as I am needing to
paste excel into ppt about 3 times a day and need to use VPC (grr)

HELP!!!

Thanks in Advance

 

[Jim Gordon MVP]

Hi CvT

As you observed, there is no readily apparent way to resize the viewing area
of the Excel workbook so that it expands what you see in the workbook. It
took me a while but I think I figured out a work-around.

This may not be the ideal solution, but it might get you around the problem.

Rather than treat the workbook as a picture, treat it as an embedded object
(this uses OLE, Object Linking and Embedding).

Save your Excel workbook as a file, then close the workbook in Excel.

In PowerPoint use Insert > Object. In the dialog box there's a radio button
on the left "Create From File." Click that radio button then navigate to
the Excel workbook. Click Insert then click OK.

The workbook may not have the proper range visible when it is imported. I
found that I could turn on the Picture toolbar (View > Toolbars > Picture)
and use the Crop tool to get rid of the blank rows or columns that appeared
in my testing. Then I could resize the result by dragging the workbook
object's handles so that everything fit nicely and displayed well.

I was able to put a workbook with 25 columns and 59 rows into PowerPoint
using this method and it worked fine.

Sure hope this helps.

-Jim
--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[Steve Rindsberg]

Does anyone have any ideas on this??? I am desperate as I am needing to

paste excel into ppt about 3 times a day and need to use VPC (grr)

Where does VPC fit in?

In any case, it might be worth looking at these and trying the suggestions
there. It's PC-centric but some of the ideas may help:

Excel info cut off when pasted into PowerPoint
http://www.rdpslides.com/pptfaq/FAQ00068.htm

Linking information from Excel
http://www.rdpslides.com/pptfaq/FAQ00593.htm

HELP!!!

Thanks in Advance

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================

 

[Steve Rindsberg]

The workbook may not have the proper range visible when it is imported. I

found that I could turn on the Picture toolbar (View > Toolbars > Picture)
and use the Crop tool to get rid of the blank rows or columns that appeared
in my testing. Then I could resize the result by dragging the workbook
object's handles so that everything fit nicely and displayed well.

It might work a wee bit better to open the Excel file, select and copy the
content you want to use in PPT, switch to PPT and Edit, Paste Special as excel
object. That seems to give me just the selected range as an embedded object.

By the way, do you know of any way to do the equivalent of an OLE Link instead
of an embed?


--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================

 

[CvT]

If you see my previous post, you can see that I am getting a problem
outlined in your first link, so I boot up into VPC and paste embedded excel
objects into ppt but in windows

 

[Steve Rindsberg]

If you see my previous post, you can see that I am getting a problem
outlined in your first link, so I boot up into VPC and paste embedded excel
objects into ppt but in windows

So VPC isn't part of the problem, it's part of the solution? Or workaround.

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================

 

[CvT]

Yes it is a workaround but one that I would like to avoid as VPC is slow
(hence the "grr")

The more I look at this, the more I think this is a bug with embedding excel
into PPT.

 

[Jim Gordon MVP]

Hi again,

When I opened the file you provided in PPT2004 I saw the limitation you
described. I double-clicked the Excel object. Then, without doing anything
further I closed and returned to PowerPoint from Excel. After returning from
Excel the entire range that you wanted to display was visible in PowerPoint.

So it's a bit odd that when you create something on your own computer that
you can't do that, but if you give the file to someone else they can.

There are some limitations and strangeness to OLE in Office for the Mac.
This is probably related to the fact that OLE version 1 is used in Mac
Office, and a more robust OLE version 2 is used in Office 2002 and 2003 for
Windows.

Microsoft folks are currently reading this newsgroup. Maybe one of them will
offer us hope that OLE level 2 is coming soon to the Mac.

-Jim
--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

-Jim

 

[Steve Rindsberg]

Yes it is a workaround but one that I would like to avoid as VPC is slow
(hence the "grr")

The more I look at this, the more I think this is a bug with embedding excel
into PPT.

Have a look at this, see if it makes any sense when applied to what you're
seeing:

Excel info cut off when pasted into PowerPoint
http://www.rdpslides.com/pptfaq/FAQ00068.htm


--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================

 

[CvT]

Hi,
It does this exactly. It seems, according to Jim, that it could be something
to do with OLE2 vs. OLE1..
CvT

 

[CvT]

Jim hi,
Thanks for this. Am I correct in assuming that you opened my file on a
Windows Machine or was it that you opened it on a os x machine?

Thanks

 

[Steve Rindsberg]

Hi,
It does this exactly. It seems, according to Jim, that it could be something
to do with OLE2 vs. OLE1..

I'm mostly a Windows guy with a Mac over there on the other desk so I can test
stuff. One thing I've learned is to trust Jim's knowhow.

 

[Jim Gordon MVP]

Hi,

I opened it on a Mac. There's no PPT 2004 for Windows.

I found another strategy for copy/paste.

In Excel, use Tools > Customize toolbars and menus. Search for the camera
command on the commands tab and drag it to any toolbar.

Then select the desired range in excel, click the camera button then click
into the worksheet someplace. A live picture of the selected range will
appear. Use the crop tool on the picture toolbar to size it as necessary.
Hold down shift then use Edit > Copy Picture. Switch to PowerPoint. Used
Edit > Paste (or Apple+V or control-click paste or whatever) to paste into a
slide.

-Jim
--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[Rolf Schmolling]

Hello!
I tried it out too and noticed that the last cell with data in it didn't
show up UNTIL I changed the object-size (of embedded worksheet) to 100%.
Still: it doesn't fit into the PP-slide.
Powerpoint seems to try to resize the embedded object so it fits in. Only
this is not possible with such a big worksheet. One wouldn't be able to read
the data if all is shown. Maybe the behaviour of PP is just about right and
one has to manually prepare the data for presentation?

Greetings Rolf