Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

migrated from serverfault.com Jul 21 '09 at 14:49

This question came from our site for system and network administrators.

    
Wouldn't that be a nice question for superuser.com? – innaM Jul 21 '09 at 14:05
    
No, I think that server fault relates to everything System Administration which this falls under. – Anonymous Jul 21 '09 at 14:16
    
Well, there's gotta be a line somewhere. Application support is a fantastic topic for SU. Use ewok.adventure as the password to join the beta. – Kara Marfia Jul 21 '09 at 14:49
    
Sounds like a perfect candidate for putting into a database somewhere rather than keep in Excel spreadsheets. – Stefan Thyberg Jul 22 '09 at 12:32
    
Thats kinda what I was thinking, but I thought I would see if anyone else had any thoughts. I work for a consulting company so as you can imagine our customers (this one is a painful one) want everything fixed but are resistant to change. But I agree that is the best option, Thanks! – Grishanko Jul 22 '09 at 20:19
up vote 1 down vote accepted

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.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .