In our office we use copy links in Excel and special paste them into Word
documents and we are having great difficulty updating our links when we open
our documents. Some people can open them and they update automatically -
when I open them up they won't update unless I got to each and every link and
hit update which is a time waster...please help.

PS - I absolutely hate 2007 version with the ribbon - please tell someone -
its a total time waster and is not user friendly - if it ain't broke - don't
fix it!!!!!!!!!! Bad, Bad, Bad Microsoft.