A few of my users use Excel spreadsheets that have cells linked to other spread sheats. It is set up so the catering.xslx pints to the inventory,comm2002.xls. I was told that excel will crash and all the links will be messed up. In one case it defaulted to the C: drive in another case it was set to the H: drive (which is the correct drive letter)But it was pointing to a excel file in that directory. (with a totalt different name)
These files are used by a few people and some are running in office 2003 SP3 and some are running Office 2007.
So I am wondering, Is there a way to prevent this from happening. And, is it possible to fix this in the event it does happen. Thanks.