cell linking causing pop-up to occur

  • I have linked cells from one workbook to another using this formula, which works great. The only problem is everytime I open the workbook that has this link in it, a message pops up asking me to link the info, then when I click yes I have to choose the appropriate file in the network. Is there a way to make it automatically choose yes for me and then find the "SEPTEMBER04" file itself by using code or something?

  • For starters, go to Edit>Links and make sure it is set to automatic. Don't know why you are having to point to the file every time, but if you are linking to the file via an assigned drive letter, I would try going the long way round and use the full path name (\\fileserver\share\directory\myfile.xls).


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!