Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
sharing a spreadsheet on a network drive
Hello all. If I have a spreadsheet on a network drive with the possiblilty of
multiple people trying to access it at one time, Can the first person open it in update mode and the rest only read only - or can i set up special permissions for this file so everyone can update it Thanks, |
#2
|
|||
|
|||
Have you looked at sharing the Workbook?
TOOLS SHARE-WORKBOOK This seems to be the route your asking about, but there are some limitations that are applied when it is converted to a shared book in relation to conditional formatting and macros. This is right out of the MS Excel help files on workbook sharing '************************ Share a workbook Create a workbook you want to make available for multiuser editing, and enter any data you want to provide. If you want to include any of the following features, add them now: merged cells, conditional formats, data validation, charts, pictures, objects including drawing objects, hyperlinks, scenarios, outlines, subtotals, data tables, PivotTable reports, workbook and worksheet protection, and macros. You can't make changes to these features after you share the workbook. On the Tools menu, click Share Workbook, and then click the Editing tab. Select the Allow changes by more than one user at the same time check box, and then click OK. When prompted, save the workbook. On the File menu, click Save As, and then save the workbook on a network location accessible to the intended users. Use a shared network folder, not a Web server.
__________________
Justin Labenne www.jlxl.net |
#4
|
|||
|
|||
Thank you, I didn't even know that existed. appreciate it!
"Abbey Normal" wrote: Hello all. If I have a spreadsheet on a network drive with the possiblilty of multiple people trying to access it at one time, Can the first person open it in update mode and the rest only read only - or can i set up special permissions for this file so everyone can update it Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Connecting to a network drive using VBA | Excel Discussion (Misc queries) | |||
Automatically save a copy of worksheet from C: to Network Drive | Excel Discussion (Misc queries) | |||
Link workbooks-C drive to network drive | Excel Worksheet Functions | |||
Some exported records do not show on spreadsheet | Excel Worksheet Functions | |||
Linking an entire worksheet from a restricted drive? | Excel Worksheet Functions |