microsoft excell spreadsheets

[Kev_md]

anybody got a clue w.t.f is going on,i set up spreadsheet with 25 tabs on it ,its updated throughout the day by owner and 1 or 2 others,problem is data keeps disapearing from file,its a shared file ,150 people use it but its only a small amount of people this is happening to ,thanks if you can help out

 

[Daz]

If it's one file, only one person can open it and then everyone else is ready only? If people are opening it in edit mode, you're going to be having all sorts of trouble.

There's DEFINETLY a better way than using an Excel sheet if 150 people use it... Heh.

 

[FiDoDiDo]

For the amount of users you have surely you would be better trying to get it into a database of some sort.

Spreadsheets aren't designed for that many users.

 

[Kev_md]

daz, whats the better way,cheers in advance:banghead:

 

[Daz]

A database system.

I presume with 150 users, it's quite a big company? I'm suprised you're even attempting an Excel sheet to be honest, Heh.

Depending what it does, you may have to go the way of a bespoke system..

 

[Kev_md]

cheers mate,much appreciated.

 

[Mike_182]

Just set up an Access database, not particularly complicated (at all!) and more than capable of dealing with 150 users...