Note - this question was also posted on the Word newsgroup, but none of the
suggested remedies were successful. I think it may be a problem with how to
reference a range name in a file in Sharepoint rather than a problem with
Word.
I would like to place a link to a table in an Excel sheet in my Word
document. I can do this successfully if the Excel file is saved locally or to
a network drive. However, if the target file is stored in Sharepoint I don't
seem to be able to use the PlaceReference parameter in the LINK function.
i.e.
{ LINK Excel.Sheet.8 "D:\\anydirectory\\Myfile.xls" "MyNamedRange" } works
correctly
{ LINK Excel.Sheet.8 "http:////myportal//anydirectory//MyFile.xls"} does not
return an error, but I get the complete Excel sheet instead of the range.
{ LINK Excel.Sheet.8 "http:////myportal//mydirectory//MyFile.xls"
"MyNamedRange"} returns the following error:
"Could not open 'http://myportal/mydirectory/MyFile.xls!MyNamedRange"
{ LINK Excel.Sheet.8
"http:////myportal//mydirectory//MyFile.xls#MyNamedRange"} does not return
and error but I get the complete Excel sheet instead of the range. Also, Word
strips out the #MyNamedRange suffix from the field code when I update it.
Is there another syntax that might work for this?
Note the syntax for the LINK field in Word is as follows:
{ LINK ClassName "FileName" [PlaceReference ] [Switches ] }
TIA
TM