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

[Jan Buckley]

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?

 

[Echo S]

Well, how did you create the link?

 

[Jan Buckley]

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?

 

[Echo S]

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

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?

 

[Jan Buckley]

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?

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

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?

 

[Jan Buckley]

Thanks, Echo. This solved the problem.

Jan

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

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?

 

[Echo S]

Another question on this same subject. Is there any way to make the links
"unbreakable" in instances where someone may move the source file?

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?

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.