Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General PowerPoint Questions / September 2007

Tip: Looking for answers? Try searching our database.

Formatting a linked Excel object

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
minnip - 13 Sep 2007 12:26 GMT
I have an object in a slide linked to an excel dataset.  

The problem I am experiencing is that the visible object on the ppt slide
extends across more rows and columns than I want it to - I can't seem to set
the excel rows and cells to be displayed in ppt.

It also displays the blue print area border. I have used the recolouring
trick to convert blue border to grey (but it is still too thick).  I have
tried amending the print area option within excel, but that has had no effect
on what I see in the ppt slide.  

I can crop the object within ppt, in the same as I would for an image, but
that is cumbersome and timely (especially across multiple linked objects).

I know there must be a simple answer - is anyone able to provide me with it
please!!

Thanks in advance
Steve Rindsberg - 13 Sep 2007 16:18 GMT
> I have an object in a slide linked to an excel dataset.  
>
> The problem I am experiencing is that the visible object on the ppt slide
> extends across more rows and columns than I want it to - I can't seem to set
> the excel rows and cells to be displayed in ppt.

Instead of using Insert, Object, Link from w/in PPT, start in Excel.
Choose the content you want in PPT, then Ctrl+C to Copy.
Switch to PPT and choose Edit, Paste Special, check mark Link and click OK.

Now you get just the stuff you selected in Excel.

> It also displays the blue print area border. I have used the recolouring
> trick to convert blue border to grey (but it is still too thick).  I have
[quoted text clipped - 8 lines]
>
> Thanks in advance

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ:  www.pptfaq.com
PPTools:  www.pptools.com
================================================

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.