Problem while Opening a excel file

[smartncute]

All,
I am working on a excel file (Naming it as A ) which is accessing data from another excel file B stored in a sharepoint location. I am using excel vba to open the file B. while testing the file A, I abruptly stopped the macro in file A several times. Then I removed the file B in sharepoint location and closed the file A. I closed the excel session i.e. I do not have any other excel files opened.
Now the problem is when I opened a new excel session and opening the file A, it seems that the file B also opening along with file A. (pls note. I deleted the file B in sharepoint location).
Can anybody assist me in this issue?
Thanks for your help.....

 

[MikeDBMan]

Dear SmartNCute:
I am no expert with SharePoint. Actually it drives me crazy with stuff like this too!
But perhaps the issue has to do with the "local" copy of your sharepoint files that may still be stored on your local hard drive.
If using Excel 2007, you can see where that path is by clicking the round circle in the upper left corner and selecting "Excel Options". Then go to the "Save" item and see what path you have in the Server Drafts Location. Open explorer and go to that path and see what files are in the folder. If you are confident that everything has been uploaded to sharepoint that may be in that path, delete all those contents. Try opening your file again and see if it helped.
Also be sure to check the links in A to make sure there are still no links to B in it. On the Data ribbon, if "Edit Links" is gray there are no external references. If not, see what it is and you may have to break the links or deal with them in some other manner.