Problem while Opening a excel file

smartncute

New Member
Joined
Oct 12, 2011
Messages
4
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). :( :confused:
Can anybody assist me in this issue?
Thanks for your help.....
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
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.
 
Upvote 0

Forum statistics

Threads
1,207,391
Messages
6,078,215
Members
446,321
Latest member
thecachingyeti

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top