powerpoint, Finding Excel document in Powerpoint link

microsoft.public.powerpoint - Microsoft Office PowerPoint


powerpoint >> Finding Excel document in Powerpoint link

by Sm9zZSBNb3VyaW5obw » Tue, 02 Dec 2008 16:06:09 GMT


How can you find the file location/name of an Excel book linked into a
Powerpoint document?

Many thanks

Jose
Top

powerpoint >> RE: Finding Excel document in Powerpoint link

by THVj » Tue, 02 Dec 2008 16:16:01 GMT


Jose,
Select the Excel object, go to Edit - Links - the path and name will be at
the bottom of the dialogue.
Luc Sanders
MVP - PowerPoint
Top

powerpoint >> RE: Finding Excel document in Powerpoint link

by Sm9zZSBNb3VyaW5obw » Tue, 02 Dec 2008 16:46:01 GMT


I selected Chart object. Edit - but "Links" is greyed out. Chart object is
edit-able however, just don't know where it is...

Jose
Top

powerpoint >> RE: Finding Excel document in Powerpoint link

by THVj » Tue, 02 Dec 2008 21:55:01 GMT

Jose,
What happens if you right-click the chart and choose Linked worksheet
object, then edit. That should lead you to the Excel file. In Excel go to
File save as and see where the Excel file is stored?
Luc Sanders
MVP - PowerPoint
Top

powerpoint >> Finding Excel document in Powerpoint link

by Steve Rindsberg » Wed, 03 Dec 2008 01:50:42 GMT

This will depend on what you have, exactly.

If you have an Excel chart linked into PPT, Luc's method will work.

If you have Excel data linked into an MSGraph Chart object, then as far as I
know, there's no way to retrieve the path to the linked file (other than by
renaming/deleting possible XLS files one by one and trying to get the chart to
update after each; when you get an error, that's your original.



In article < XXXX@XXXXX.COM >, Jose Mourinho
Top
Similar Threads

1. Linking and Embedding Word and Excel documents into Powerpoint (20 

I am having problems when I insert word and excel documents into Powerpoint 
presentations as objects.  The printed version of the presentation has the 
same format as the excel or word object, yet a lot of the slides in 
presentation mode will have lines in the chart that are missing, mysterious 
blank spaces where chart lines should be.  Resizing does not seem to help.  
All of the programs are the 2002 version.  Any ideas?

2. How to paste excel document with live links in Powerpoint

3. Links to Excel cells no longer found

4. Find linked Excel path

5. Finding the source of the Excel data linked to a chart datasheet 

I can link my excel data to the ms graph datasheet for a chart in Powerpoint 
and it updates just fine. 

But what if I do not know the name of the source file in Excel?  The links 
command doesn't show the link.  But the software knows it is there.  Can 
someone help me locate the info?

6. How can I find the name of the excel file that I linked into msgra

7. Updating links to multi-worksheet Excel document via VBA 

Does anyone have any sample code they can send that would 
show how to change source files for a powerpoint 
presentation that has a PPT slide per Excel Worksheet.  
This is a multi page/worksheet presentation and users 
could accidentally rename the excel doc that feeds it.  I 
need a solution to browse to the new file location and 
update links.  Manually you have to update one slide at a 
time in Powerpoint...

8. Linking data from Excel to PowerPoint (without paste link)