Archive of Mr Excel Message Board

if u don't want to update link..just delete
the other workbook..u want the code..?

I'm needed to update the link on command. In other words, keep the reference and re-calculate to update links.

Thanks for the effort though.

plz elaborate it more clearly..maybe me or
others can help you..your question is not details.

Have you ever linked a file by vlookup? (not being a smart@$$) When I open the file, I'm prompted to answer "yes, to update links" or "no, keep existing info." I do not want to update at this time. I do not want to see the dialog box. I can turn the dialog box off by un-checking the "Ask to update automatic links" box, but the links try to update automatically. I don't want this to happen. I do not want the links to update unless I want them to (by recalculating by using F9).

Situation: Other people may open this same file. I don’t want them to update this spreadsheet. I don’t even want them to be prompted. I only want this file updated after the lookup file has been completely updated (could be weeks later). Sorry for the lack of explanation.

Thanks again.