two way workbooks

[SandraR]

Hi
Does anybody know how to create a two way link for multiple excel workbooks.
In otherwords, i have a master workbook where i allocate jobs to different
people. I also have multiple workbooks so that whatever job is allocated to a
certain person this job will appear on his workbook.
But now i would like to add that if that person updates his workbook with
details about that job it should in tern update my master workbook.

i hope this makes sense.....

 

[Arvi Laanemets]

Hi

It is possible, but you have to limit, which user can edit what kind of
information. I.e. when somebody's task is to enter jobs and allocate people
to jobs in master workbook, then in other workbooks those data are read in
using link formulas, or ODBC query, and users tehre can't edit them in any
way - they can only enter some additional info (p.e. job status, or spent
hours, etc.). And this additional info may be read into master workbook
again - but only for viewing. So every user is editing strictly his own data
only.

 

[Dave Peterson]

Excel isn't made for this kind of thing and I think it would be very difficult
to implement a robust solution.

If you have data that multiple users should be changing at the same time, then
you may want to look at a real database program -- Access???