View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ty Archer Ty Archer is offline
external usenet poster
 
Posts: 5
Default Links Not saving?

Hi,
Can anyone help me with a problem I am having with my links. I have a main
file that is on a mapped drive. This file has formulas that are linked to
other files within different sub folders. Each time I open the main file it
ask to update the link, and I select Yes, however, some of the links give me
ERR.

When I select the cell to see if the link is ok, the link appears to be ok.
However, when I refresh the link it gives me a dialog box to find the linked
file. I find it, then save it, and when I reopen the file I get the same
error again, and again and again. I have many links in this file and it is
tedious to relink again and again.

Can anyone please help me? Thank you very much for you kind assistance.