SourceFullName Question

[pdog763]

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.

 

[pdog763]

I have to clarify the version of Powerpoint I am using. It is 2003.