General discussion

Locked

Won't remember linked file in excel

By lmcdonald ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by BFilmFan In reply to Won't remember linked fil ...

Has the location of the linked file changed?

Is DFS involved?

Collapse -

by lmcdonald In reply to Won't remember linked fil ...

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..

Collapse -

by lmcdonald In reply to Won't remember linked fil ...

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)

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums