I have linked two worksheets. When I open the file and tell it to update all
links the it tells me "File Not Found" if I search for the file and select it
then it say "Macro1 not found on {File Name} (this is the name of my file).
Then I hit OK on the pop up messages and eventually I get to my page and it's
all updated. If I just hit cancel when it tells me the file isn't found then
I go right to my page and it's all linked. If the links work then why is it
telling me that the files arent' found and how can avoid it. It's really
annoying.