Links in Excel changed after a crash

Links in Excel changed after a crash

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)

Asked by: Guest | Views: 210

Total answers/comments: 1

Comments display order:

Guest [Entry]

It looks like an Access data base will work. To overcome the issue of multipal users accessing it the same time I will split the DB. Thus giving me the front end and back end files. This should allow multipal users to access it without causing corruption.