Link to exterrnal document

  • Thread starter Thread starter Optiglaze
  • Start date Start date
O

Optiglaze

(Excel 97)
Hi,
I have an excel file which links to another, it used to do this without
prompting when opened until I had a bit of a move around.
Now when I open the file it asks me if I want to update and prompts me for
the location.

How do I set excel to look in a particular directory and update
automatically?

Many thanks,

Rick
 
If you answer no to the prompt, you should be able to update the links via
Edit|Links.

Then if you save that workbook with the updated links, the next time you open
the workbook, you should be set.

That said, there are a lot of links that can be difficult to find. When I can't
find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm
 
Back
Top