When I open a file with links to another file, a security warning shows in
the message bar showing that automatic update of links has been disabled.
When I go to the Trust Centre it shows that Prompt User on Automatic Update
of Links is selected.

I have a word document in 2003 format that had hyperlinks with graphs created
in an excel 2003 file. The links were updated automatically  every time the
data (graphs) were refreshed in the excel.
After upgrading to office 2007  the hyperlinks from the excel to the word

I'm trying to vary the source of some information, How can I use a drop down
list for example to select a new source for info in a cell?
example:
Q:\Data\File001.xls

For the footers on my excel documents, I am requried to include the complete
file path.
When I email the docs to another user, the file path changes.  This creates
a problem when I email the docs to the copy center to have them printed.  The

can anyone guide me?
I have a worksheet with hyperlinks but when I protect the worksheet i
am unable to use the hyperlink even though I have unprotected the range
where the hyperlink is noted