Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shared use of excel work books
Hi,
Can anyone tell me "if I have an excel workbook (with multiple worksheets that report to the first worksheet) on a shared drive whether it can be set up for multiple users to access it and use it at the same time?" These users will be accessing their single worksheet to update it periodically with the first worksheet being the project leaders sheet where he gets to see all the other worksheets on his one sheet. -- Ian |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shared use of excel work books
Hi Ian,
You can do this by selcting "shareworkbook" from the tools menu and checking the 'allow changes by more than one use'. Beware tho users must never save their changes by using the 'save as' from the file menu. Doing this would mean changes by other users would be lost. Always using the save icon on the toolbar ensures changes from all users at the same time are merged. I may be wrong but I do not think you will be able to ensure that each individual users worksheet or the project leaders sheet is private to the individual user, if this is what you are trying to do. Sharedworkbooks also have a few limitations.... password/data validations/conditional formats etc cannot be set upwhile the workbook is shared, but can be set up before sharing the workbook. "Ian" wrote: Hi, Can anyone tell me "if I have an excel workbook (with multiple worksheets that report to the first worksheet) on a shared drive whether it can be set up for multiple users to access it and use it at the same time?" These users will be accessing their single worksheet to update it periodically with the first worksheet being the project leaders sheet where he gets to see all the other worksheets on his one sheet. -- Ian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Work book shared | Excel Discussion (Misc queries) | |||
Work books | Excel Worksheet Functions | |||
Problem Editing Macro in Shared Excel File | Excel Discussion (Misc queries) | |||
Problem Editing Macro in Shared Excel File | Excel Discussion (Misc queries) | |||
How can I prevent a Excel file which is set as shared being chang. | Excel Worksheet Functions |