SourceFullName Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Powerpoint 2007. I have a linked graph from Excel in my
presentation. When I go to the Links tab and change the source file for the
graph it does not change. It still retains the data from the first file.

I looked at the SourceFullName property of the LinkObject and it is
interesting to me so perhaps someone can help me figure it out. It is in the
following form (I have inserted spaces here between the components to make it
easier to read):

Path \ OldExcelFile.xls ! Worksheet ! [OldExcelFile.xls] Worksheet ObjectName

when I change the source the path and filename change in the first portion
of the string but the old excel file name still exists between the brackets.
The new SourceFileName is in the following format

NewPath \ NewExcelFile.xls ! Worksheet ! [OldExcelFile.xls] Worksheet
ObjectName

Can someone tell me why this property would have multiple references to the
filename and worksheet name, and more importantly how can I fix this? Thanks
for your help.
 
I am using Powerpoint 2007.
Click to expand...

Actually 2003 as you mentioned later; just adding it here so all the
information's in one place.
I have a linked graph from Excel in my
presentation. When I go to the Links tab and change the source file for the
graph it does not change. It still retains the data from the first file.
Click to expand...

Had you previously saved the source file? Earlier versions of PPT would not let
you LINK to an Excel file until you'd first saved it. Now, you're able to link
to an unsaved file. I can't begin to fathom why they'd permit this other than
"It's a bug". Links to unsaved files are guaranteed to break.

What exactly did you do to change the source file?

Is the link set to update automatically?
I looked at the SourceFullName property of the LinkObject and it is
interesting to me so perhaps someone can help me figure it out. It is in the
following form (I have inserted spaces here between the components to make it
easier to read):

Path \ OldExcelFile.xls ! Worksheet ! [OldExcelFile.xls] Worksheet ObjectName
Click to expand...

Without knowing the exact steps you followed, I can't be sure I'm reproducing
what you did, but when I tried, the only time I could get PPT to show this odd
syntax is when I'd linked to an unsaved XLS file.

when I change the source the path and filename change in the first portion
of the string but the old excel file name still exists between the brackets.
The new SourceFileName is in the following format

NewPath \ NewExcelFile.xls ! Worksheet ! [OldExcelFile.xls] Worksheet
ObjectName

Can someone tell me why this property would have multiple references to the
filename and worksheet name, and more importantly how can I fix this? Thanks
for your help.
Click to expand...
 
Back
Top