I am working in Excel 2007 and my goal is to create a spreadsheet that is linked to a couple of different Excel files that are posted to two different SharePoint links and updates automatically based on updates that are made to those files on SharePoint.

I have inserted objects through the following path: Insert --> Object --> Create From File, using the SharePoint URL as the file name and checking "Link to File."

The links objects seem to be inserted okay, and I am able to open them once by double clicking. However, when I go to open the linked objects by double clicking again, I get the error message "Cannot start the source application for this object," and I cannot get them to open again. Any idea what is going on here?