I have an Excel file (file A) with a link to another Excel file (File B). File B is on a SharePoint server that is no longer available and when I open file A it tries to connect to the missing SharePoint server. No error is produced, and Excel then proceeds to display nothing, as if there is no file open. However, file A is open because when I try to close Excel it prompts me to save changes.
Both file A and B are Excel 2003 and I am using Excel 2007.
EDIT: I have now used both Excel 2007 and Excel 2003 to open the file. While 2007 behaves as previously described, 2003 crashes on opening the file, whether macros or links are enabled or disabled.
I should also mention that I tried opening older version of the file, which were clearly fine at some point (since people modified them), and the behavior remains the same. This leads me to conclude that it is strictly related to the link to the unavailable file.
I have two questions:
- Why does the file not show up?
- How can I disable the data link, which I suspect has something to do with the malfunction (all buttons on the ribbon are disabled, including the links one)?