Software

Ask something
Discussion Locked

Won't remember linked file in excel

0 helpful
3 replies

by lmcdonald 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a file that is linked to another file for lookup. All of a sudden everytime I open the file and add entries it opens a file open box looking for the linked file. Even if I already have the file open. I never had this happen before. Any suggestions???

Thank you

3 replies

by lmcdonald

The location of the linked file changed temporarily. It is in a newly mapped location. But in my lookup formula I changed it to point to the new location. I don't get why everytime I copy the lookup formula it brings up the file open window and wants me to point to the linked file again. Even if the file is already open...
Thanks for the help..

by lmcdonald

I redid the change source for links for the file. Even though I had already done this previously, for some reason it worked (at least for now)

This discussion is closed to new replies.