Any better solution?

  • Thread starter Thread starter Bluie
  • Start date Start date
B

Bluie

I have an excel file that needs to be updated frequently, 2 times
week. And when wanting to update, it will be updated by 3-5 person. A
the moment, how we update is A would update it, save and email to B.
would update it, save and email to C.

Therefore, is there any better solution of how this updating can b
done a better way? My idea is to put the file in a server where A,B an
C can access to it and update(modify data) it. But can 3 person updat
this file at the same time?

Hope to get some advise / comments / solution.

Thank you
 
Hi

Several persons can't edit same data (or anything in workbook) at same time.
When someone opens workbook, until he/she closes it again, all others are
allowed to open it as read-only (with notification or without it).

When there is the slightest possibility to separate data so, that every user
updates only his data, then I advice to put own file for every user on
server. You can create a summary file, which reads data from user files
using links or ODBC query, and displays them in raw (as they are in users
workbooks) or in consolidated (summary data) form. With either of solutions,
opening summary workbook don't hinder other users to open their workbooks
and to edit their data.
 
Back
Top