Paste from Excel to PowerPoint

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I have office 2000. When you paste a selection larger
than 69 rows from Excel to PowerPoint, PowerPoint
truncates the 70th and following rows. I have found no
way to show the additional rows after you have pasted the
data. If you make the font smaller before pasting the
data you can view a few more rows, but again there is no
way to resize the pasted data once it is in PowerPoint. I
have also noticed that not only is the data that you paste
copied over, the entire spreadsheet that the data came
from is pasted over.

Are these problems normal? How do you get around these
limitations?

Thanks,
Keith
 
I have office 2000. When you paste a selection larger
than 69 rows from Excel to PowerPoint, PowerPoint
truncates the 70th and following rows.
Click to expand...

It's more a size limitation rather than number of rows (that is, if you make
the row height larger in Excel, you'll probably see it cutting off after a
smaller number of rows).

This explains in more detail:

Excel info cut off when pasted into PowerPoint
http://www.rdpslides.com/pptfaq/FAQ00068.htm
I have found no
way to show the additional rows after you have pasted the
data. If you make the font smaller before pasting the
data you can view a few more rows, but again there is no
way to resize the pasted data once it is in PowerPoint.
Click to expand...

No, because the link is to a specific range of cells in the sheet.
To change the range, you have to go back into Excel and re-select/repaste (or
manually edit the link, perhaps).
have also noticed that not only is the data that you paste
copied over, the entire spreadsheet that the data came
from is pasted over.
Click to expand...

That's correct. It's how embedded OLE objects work. The entire source file is
embedded (otherwise, you wouldn't be able to invoke the source for further
editing by doubleclicking on it)

You can break the link and ditch the excess data by ungrouping the object in
PPT once it's formatted and sized to taste.

Most of us find we have better luck with linking instead. Select the content
you want in Excel, copy, switch to PPT, choose Paste, Special, put a check next
to Link and click OK. Now the data's linked back to the source excel file, but
not actually in the PPT file. As long as PowerPoint can find the XLS, it'll
update the PPT whenever you open it, using the most recent data in the XLS.
Nice feature. Again, ungrouping the content in PPT breaks the link.
 
Back
Top