I have a spreadsheet that contains hyperlinks to Word docs and pdfs of
reports. The spreadsheet contains database information that can direct my
users to reports that were previously written on specific subjects. The
hyperlinks were all set up to be directed to docs in a specific folder on
server. Recently I've added to the additional references and hyperlinks to
that spreadsheet. When I open the spreadsheet yesterday, all links had
changed and now show the hyperlink address to my workstation hard drive, not
the server. If I add new links today, they show the server as the location,
but all previously established links now refer to my workstation hard drive
and I cannot connect to the document because the hyperlink directs me to the
wrong place. And I don't want to re-link those 300 documents. Can you help?