Sharing a worksheet among multi. Users over Network.
 

Hello all,
I work in a call center, and we currently use excel to manage our phone
list. This phone list contains extentions, positions titles, and names and
in/out status--and it is searchable.
Problem:
Manageing the list the current way has provided some obstacles during the
day. Every user of the lists is accessing one excel file that is located on
the network.
It is difficult to update the list while it is still in use and opened by
the users. I was hopeing that someone might have an idea of an excel tool or
function that may make this process easier. I envision a master list which
can be modified at anytime, to be used by the admin, and a "client" or reader
of this master list which is viewable via the network.
It seems pretty basic to me, but I still cant figure it out. Please, any
help would be greatly appreciated. Thank you everyone.

Sharing a worksheet among multi. Users over Network.
 

Adrian :

A master list is the best with the user accessing the data from another
workbook

The best method is to use access and you can actually build a seperate
database and the application and then the data is updated in real time.

You then need to design your database and write the appliation to ensure
reliablitly.



--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Adrian3a" wrote:

Hello all,
I work in a call center, and we currently use excel to manage our phone
list. This phone list contains extentions, positions titles, and names and
in/out status--and it is searchable.
Problem:
Manageing the list the current way has provided some obstacles during the
day. Every user of the lists is accessing one excel file that is located on
the network.
It is difficult to update the list while it is still in use and opened by
the users. I was hopeing that someone might have an idea of an excel tool or
function that may make this process easier. I envision a master list which
can be modified at anytime, to be used by the admin, and a "client" or reader
of this master list which is viewable via the network.
It seems pretty basic to me, but I still cant figure it out. Please, any
help would be greatly appreciated. Thank you everyone.