How do I link data from Excel to a PowerPoint slide?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've read the various responses to this question, and managed to link the
data from an Excel spreadsheet to a PowerPoint slide. However, the data
appears in a box, and the font is quite small. How can I remove the box and
increase the size of the font so it will be the same size as the other text
on the slide? Thanks for your time?
 
Copied the data from the source file, opened the destination file, clicked
Edit, Paste Special, Paste as Link.

Echo S said:
Well, how did you create the link?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com


Jan Buckley said:
I've read the various responses to this question, and managed to link the
data from an Excel spreadsheet to a PowerPoint slide. However, the data
appears in a box, and the font is quite small. How can I remove the box
and
increase the size of the font so it will be the same size as the other
text
on the slide? Thanks for your time?
Click to expand...
Click to expand...
 
Okay, thanks.

To get rid of the gridlines, you'll have to turn them off in Excel. In
Excel, go to Tools|Options|View and uncheck Gridlines.

You should also change the font size in the Excel spreadsheet. Then in PPT,
you can right-click the linked Excel object, choose Format Object, and make
sure it's set to 100% x 100% in the Size tab. (It should come in at that
100% size, but if it doesn't, that's where you can change it.)

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com


Jan Buckley said:
Copied the data from the source file, opened the destination file, clicked
Edit, Paste Special, Paste as Link.

Echo S said:
Well, how did you create the link?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com


Jan Buckley said:
I've read the various responses to this question, and managed to link
the
data from an Excel spreadsheet to a PowerPoint slide. However, the data
appears in a box, and the font is quite small. How can I remove the box
and
increase the size of the font so it will be the same size as the other
text
on the slide? Thanks for your time?
Click to expand...
Click to expand...
Click to expand...
 
Another question on this same subject. Is there any way to make the links
"unbreakable" in instances where someone may move the source file? And what
will happen if the source file is sorted? Does this have any effect on the
linked file?

Echo S said:
Okay, thanks.

To get rid of the gridlines, you'll have to turn them off in Excel. In
Excel, go to Tools|Options|View and uncheck Gridlines.

You should also change the font size in the Excel spreadsheet. Then in PPT,
you can right-click the linked Excel object, choose Format Object, and make
sure it's set to 100% x 100% in the Size tab. (It should come in at that
100% size, but if it doesn't, that's where you can change it.)

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com


Jan Buckley said:
Copied the data from the source file, opened the destination file, clicked
Edit, Paste Special, Paste as Link.

Echo S said:
Well, how did you create the link?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com


I've read the various responses to this question, and managed to link
the
data from an Excel spreadsheet to a PowerPoint slide. However, the data
appears in a box, and the font is quite small. How can I remove the box
and
increase the size of the font so it will be the same size as the other
text
on the slide? Thanks for your time?
Click to expand...
Click to expand...
Click to expand...
 
Thanks, Echo. This solved the problem.

Jan

Echo S said:
Okay, thanks.

To get rid of the gridlines, you'll have to turn them off in Excel. In
Excel, go to Tools|Options|View and uncheck Gridlines.

You should also change the font size in the Excel spreadsheet. Then in PPT,
you can right-click the linked Excel object, choose Format Object, and make
sure it's set to 100% x 100% in the Size tab. (It should come in at that
100% size, but if it doesn't, that's where you can change it.)

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com


Jan Buckley said:
Copied the data from the source file, opened the destination file, clicked
Edit, Paste Special, Paste as Link.

Echo S said:
Well, how did you create the link?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com


I've read the various responses to this question, and managed to link
the
data from an Excel spreadsheet to a PowerPoint slide. However, the data
appears in a box, and the font is quite small. How can I remove the box
and
increase the size of the font so it will be the same size as the other
text
on the slide? Thanks for your time?
Click to expand...
Click to expand...
Click to expand...
 
Jan Buckley said:
Another question on this same subject. Is there any way to make the links
"unbreakable" in instances where someone may move the source file?
Click to expand...

Not that I'm aware.

I'll confess that this kind of linking isn't my strong suit, though. You
might want to check into FixLinks Pro
http://www.rdpslides.com/pptools/fixlinks/index.html and see if it will help
you. It won't prevent link breakage, but it does help fix them if they're
broken. Or you might check in the Edit|Links menu in PPT -- I'm not sure how
reliable "change source" is there, but it would be worth looking at if you
end up with a broken link.
And what
will happen if the source file is sorted? Does this have any effect on the
linked file?
Click to expand...

When you open the PPT file, you should be prompted to update links or not.
If you update them, the display in the PPT file will reflect any changes
(such as sorting) that have been made to the linked Excel file.
 
Jan Buckley said:
Another question on this same subject. Is there any way to make the links
"unbreakable" in instances where someone may move the source file?
Click to expand...

If you embed the information rather than linking, the source file will no longer
be required.

With linked Excel content, PPT will generally find the linked file if it's in
the same folder as PPT or if it's wherever the link points. Otherwise, no, and
nothing much can be done about it.
And what
will happen if the source file is sorted? Does this have any effect on the
linked file?
Click to expand...

The link points to the file and a range of cells within the file. Sorting will
most likely change the data that's in that range, so PPT will display the new
contents of the range the next time you open the PPT and the link is updated.
Echo S said:
Okay, thanks.

To get rid of the gridlines, you'll have to turn them off in Excel. In
Excel, go to Tools|Options|View and uncheck Gridlines.

You should also change the font size in the Excel spreadsheet. Then in PPT,
you can right-click the linked Excel object, choose Format Object, and make
sure it's set to 100% x 100% in the Size tab. (It should come in at that
100% size, but if it doesn't, that's where you can change it.)

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com


Jan Buckley said:
Copied the data from the source file, opened the destination file, clicked
Edit, Paste Special, Paste as Link.

:

Well, how did you create the link?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com


I've read the various responses to this question, and managed to link
the
data from an Excel spreadsheet to a PowerPoint slide. However, the data
appears in a box, and the font is quite small. How can I remove the box
and
increase the size of the font so it will be the same size as the other
text
on the slide? Thanks for your time?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top