up vote 3 down vote favorite
share [g+] share [fb]

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.

link|improve this question
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
feedback

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

This question came from our site for system administrators and desktop support professionals.

1 Answer

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.