Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
two way workbooks
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..... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
two way workbooks
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. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "SandraR" wrote in message ... 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..... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
Display 2 formulas from source workbooks to destination workbooks | Excel Discussion (Misc queries) | |||
suddenly my excel workbooks are "shared workbooks" | Excel Discussion (Misc queries) |