Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data sharing
Hi,
I have one excel file where we insert information constantly on one desk. But we also have another person who needs to insert more information on his side on another part of the office. How can I share some columns so every time the second person needs to add data, wont have the problem that the file is open [read only] by the other user? JPG |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data sharing
Use two separate workbooks and merge the results periodically.
-- Gary''s Student - gsnu200758 "juanpablo" wrote: Hi, I have one excel file where we insert information constantly on one desk. But we also have another person who needs to insert more information on his side on another part of the office. How can I share some columns so every time the second person needs to add data, wont have the problem that the file is open [read only] by the other user? JPG |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data sharing
And how do I merge the results?
The information is so time critical, that the main workbook needs to be updated automatically. JPG "Gary''s Student" wrote: Use two separate workbooks and merge the results periodically. -- Gary''s Student - gsnu200758 "juanpablo" wrote: Hi, I have one excel file where we insert information constantly on one desk. But we also have another person who needs to insert more information on his side on another part of the office. How can I share some columns so every time the second person needs to add data, wont have the problem that the file is open [read only] by the other user? JPG |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data sharing
XL does not handle concurency well, which is what you are asking for. My
suggestion would be to use a database such as Access. If you want you can have XL write to an access database using macros but that is a little tricky and not a good project unless you are an experienced VBA programmer. -- HTH... Jim Thomlinson "juanpablo" wrote: And how do I merge the results? The information is so time critical, that the main workbook needs to be updated automatically. JPG "Gary''s Student" wrote: Use two separate workbooks and merge the results periodically. -- Gary''s Student - gsnu200758 "juanpablo" wrote: Hi, I have one excel file where we insert information constantly on one desk. But we also have another person who needs to insert more information on his side on another part of the office. How can I share some columns so every time the second person needs to add data, wont have the problem that the file is open [read only] by the other user? JPG |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data sharing
But that is not true.
I just found that under Tools -Share workbook, that works perfect. Best regards JPG "Jim Thomlinson" wrote: XL does not handle concurency well, which is what you are asking for. My suggestion would be to use a database such as Access. If you want you can have XL write to an access database using macros but that is a little tricky and not a good project unless you are an experienced VBA programmer. -- HTH... Jim Thomlinson "juanpablo" wrote: And how do I merge the results? The information is so time critical, that the main workbook needs to be updated automatically. JPG "Gary''s Student" wrote: Use two separate workbooks and merge the results periodically. -- Gary''s Student - gsnu200758 "juanpablo" wrote: Hi, I have one excel file where we insert information constantly on one desk. But we also have another person who needs to insert more information on his side on another part of the office. How can I share some columns so every time the second person needs to add data, wont have the problem that the file is open [read only] by the other user? JPG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sharing data between Excel and Access | Excel Discussion (Misc queries) | |||
Data sharing | Excel Discussion (Misc queries) | |||
Sharing Data by Keyword | Excel Worksheet Functions | |||
Looking for suggestion - data sharing | Excel Discussion (Misc queries) | |||
Sharing Data Between Worksheets | New Users to Excel |