View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default two way workbooks

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???


SandraR wrote:

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.....


--

Dave Peterson