When I try to point my PowerPivot report to the source file (by browsing to the excel file) and say - Save. Check attached Image 1 and Image 2.
I get attached Error ( Image 2).
ERROR : The file you have chosen is in use. Please close the file before you import.