search
Twitter Rss Feeds
MicrosoftArticlesForumsGroups
C# .NET
VB.NET
Visual Studio .NET
ADO.NET
Xml/Xslt
VB 6.0
.NET CF
GDI+
LINQ
Deployment
Security
FoxPro
Silverlight / WPF
Entity Framework
RIA Services

Web ProgrammingArticlesForumsGroups
JavaScript
ASP
ASP.NET
Web Services

Non-MicrosoftArticlesForumsGroups
NHibernate
Perl
PHP
Ruby
Java
Linux / Unix
Apple
Open Source

DatabasesArticlesForumsGroups
SQL Server
Access
Oracle
MySQL
Other Databases

OfficeArticlesForumsGroups
Microsoft Excel
Microsoft Word
Microsoft Powerpoint
Publisher
Money

Operating SystemsArticlesForumsGroups
Windows 7
Windows Server
Windows Vista
Windows XP
Windows Update
MAC
Linux / UNIX

Server PlatformsArticlesForumsGroups
Share Point
BizTalk
Site Server
Exhange Server
IIS
Transaction Server

Graphic DesignArticlesForumsGroups
Macromedia Flash
Adobe PhotoShop
Microsoft Expression

OtherArticlesForumsGroups
Subversion / CVS
Ask Dr. Dotnetsky
Active Directory
Networking
Uninstall Virus
Job Openings
Reviews
Search Engines
Resumes

 

Previous Thread:   Do you need MS Powerpoint to view a .pps file?

9/28/2005 5:42:03 AM    Excel charts in PowerPoint
Question 1  
  
When I copy an Excel chart into PowerPoint, PasteSpecial does not allow me  
  
to paste link -- the box is greyed out. I get the option to paste the chart  
  
as MS Office Drawing Object, Picture (Windows Metafile) and Picture  
  
(EnhancedMetafile)  
  
What do I need to do?  
  
Question 2  
  
I've also tried to use the 'reduce size' embedding suggested by Brian Reilly  
  
and reproduced by Steve Rindsberg on  
  
http://www.rdpslides.com/pptfaq/FAQ00593.htm. When I do, double clicking on  
  
the chart reveals the original Excel file with the chart page I'd copied into  
  
a new workbook as an additional page.  
  
Again, what do I need to do?  
  
Thanks in advance  
  
Henrik

10/3/2005 12:21:35 PM    Re: Excel charts in PowerPoint
Henrik,  
  
Paste Link is only available after the Excel file has been saved. You  
  
probably hadn't saved it yet when you tried that.  
  
The second point is expected as well. The Excel file retains the link  
  
to the original source workbook. It was a trick we used to use in PPT  
  
97 which didn't have the PasteSpecial method available in VBA code.  
  
Brian Reilly, MVP  
  
On Wed, 28 Sep 2005 08:14:02 -0700, Henrik  
  
<Henrik@discussions.microsoft.com> wrote:

10/4/2005 10:38:04 PM    Re: Excel charts in PowerPoint
In article <4F8D3189-0EB3-4AB8-B4CD-994B8DBC52DC@microsoft.com>, Henrik wrote:  
  
Here's a guess:  
  
The first time, you copied the content from Excel, started PPT then tried to Edit,  
  
Paste Special.  
  
The second time, you already had PowerPoint running when you tried the copy/paste  
  
special.  
  
If you're running certain add-ins (Adobe's PDF add-ins for example) they put stuff  
  
on the clipboard when PPT starts up.  That wipes out whatever you put there from  
  
Excel, leaving just a picture of their icon.  
  
That's why you see the odd behavior in the first case but not the second.  
  
Does that seem to match what you're seeing?


Pete's Blog   |    Pete's Resume   |    Robbe's Blog   |    Robbe's Resume   |    Archive #2   |    Archive #3   |    Dotnetslackers   |    XmlPitStop   |    Advertise   |   Contact Us   |   Privacy   |   Copyright (c) 2000 - 2009 eggheadcafe.com  All rights reserved.