File with VLOOKUPs looking for a phantom file
Hi, I have a workbook with vLookups to 4 other files which work ok. The
problem arises when I want to run formatting macros. It runs but then
produces the "Update File" explorer box and is looking for a file name which
does not exist.
The file it is looking for is only one character different from the
original file.
I have looked at some of the post's and the recommendation to use add-ins
is not available to me as I am working on a networked computer which is
restricted.
Any Ideas greatfully accepted.
Davie
|