Linking to Excel

[Guest]

Can anyone advise how I can link to an existing Excel file
and to a specific TAB within that file. I know how to
link from Powerpoint to Excel but am unsure how to link to
a specific tab within the file itself. Thank you.

 

[Guest]

Thanks for the information. I also was able to determine
that the way you would type in a link is as follows:

C:filename.xls#'tab name'!A1

A1 is the cell that you want to go to initially. You do
need the single quotes and !.

Thanks again.

-----Original Message-----

 

[voodoo]

Your response is a clue to a problem I am trying to solve.

You said you manually typed in the path to a link?
Where can I do that within PowerPoint?

I want to manually edit existing links in my .ppt. The "Change Source"
feature is not smart enough to allow me to choose a tab or chart
within a spreadsheet.

Thanks for the information. I also was able to determine
that the way you would type in a link is as follows:

C:filename.xls#'tab name'!A1

A1 is the cell that you want to go to initially. You do
need the single quotes and !.

Thanks again.

 

[G Coco]

Thanks Steve.
Ok, I read about the VBA code that can be used to ask the user (me) to
choose a new link source. Of course, every answer creates 3 new
questions. So...

1) Where in PP do insert this code?

2) What triggers the code being run?

3) Having once been a systems programmer it looks to me like this code
does not allow me to point to specific object such as a chart within a
spreadsheet. Instead, the code looks like it lets me simply choose a
file (it returns the path to the file). But this is exactly what the
"Change Source" feature in the "Edit Links" dialog does.

Thanks,
Geoff Coco
(e-mail address removed)

 

[G Coco]

That worked quite well.
And, you taught a man to fish!