View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
davethewelder davethewelder is offline
external usenet poster
 
Posts: 62
Default 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