Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Multiple user excel file
I want to create an excel file which can be use by multiple user at a time
and the data updated in these files should bet stored in a centralized user file. I don't know how to go about it. Could you please help me out with this? I have created that input excel file using forms. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Multiple user excel file
one way to do it is to create multiple excel files and use a master file to link them all. e.g. create 4 files, master.xls, user1.xls, user2.xls, user3.xls formula in master.xls: A B C =[user1.xls]Sheet1!A1. =[user1.xls]Sheet1!B1. =[user1.xls]Sheet1!C1 =[user2.xls]Sheet1!A2. =[user1.xls]Sheet1!B2. =[user1.xls]Sheet1!C2 =[user3.xls]Sheet1!A3. =[user1.xls]Sheet1!B3. =[user1.xls]Sheet1!C3 for this example to work all the files must reside in the same file directory. another way is to use the same idea but implement it on different worksheet tabs. hope this helps. Yong Heng "Nithin" wrote: I want to create an excel file which can be use by multiple user at a time and the data updated in these files should bet stored in a centralized user file. I don't know how to go about it. Could you please help me out with this? I have created that input excel file using forms. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sharing Excel file for multiple user | Excel Discussion (Misc queries) | |||
Need to Query Excel File Opened by Another User | Excel Discussion (Misc queries) | |||
Preventing an excel file from being deleted by another user | Excel Discussion (Misc queries) | |||
Excel allows access to more than one user to same file | Excel Discussion (Misc queries) | |||
User cannot save excel file in workbook | Excel Worksheet Functions |