Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Users in One Sheet
Hello, is there a way to grant access for multiple people into one
spreadsheet located on a shared drive? So that a group of people could go in and work on it at the same time and save changes? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Users in One Sheet
Sure. Look under Tools/Share Workspace. Tools/Share Workbook. Tools/Track
changes. But I suggest you read up on this subject. "nabanco" wrote in message ... Hello, is there a way to grant access for multiple people into one spreadsheet located on a shared drive? So that a group of people could go in and work on it at the same time and save changes? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Users in One Sheet
Also, terminology. When you say spreadsheet, you're actually referring to a
workbook. Workbooks contain spreadsheets known as worksheets. :) "nabanco" wrote in message ... Hello, is there a way to grant access for multiple people into one spreadsheet located on a shared drive? So that a group of people could go in and work on it at the same time and save changes? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Users in One Sheet
You are right, I am referring to a workbook, sorry.
Are there any major concerns you see with sharing a workbook? You seem to stress reading up on the subject "Dave Thomas" wrote: Sure. Look under Tools/Share Workspace. Tools/Share Workbook. Tools/Track changes. But I suggest you read up on this subject. "nabanco" wrote in message ... Hello, is there a way to grant access for multiple people into one spreadsheet located on a shared drive? So that a group of people could go in and work on it at the same time and save changes? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Users in One Sheet
Yes. When you have more than one person working on a workbook, you can have
more than one person change the same cell(s). Someone is normally in charge of a workbook and supervises the changes made to it. With Tools/Track Changes, you can see who changed what and accept or reject any changes. I change cell A6 to "Bill". Someone else changes A6 to "Charlie". And yet someone else changes A6 to "Anita". Who makes the decision what should be in A6? The person in charge of the workbook, usually the owner, using Tools/Track Changes to see who made the changes to A6 makes the decision as to what A6 should be.You can also distribute the workbook to multiple users and then merge the distributed workbooks later, and someone has to make decisions regarding conflicts - if two or more people change the same thing(s), whose changes take priority? I strongly suggest you read up on this. It is called workbook collaboration. "nabanco" wrote in message ... You are right, I am referring to a workbook, sorry. Are there any major concerns you see with sharing a workbook? You seem to stress reading up on the subject "Dave Thomas" wrote: Sure. Look under Tools/Share Workspace. Tools/Share Workbook. Tools/Track changes. But I suggest you read up on this subject. "nabanco" wrote in message ... Hello, is there a way to grant access for multiple people into one spreadsheet located on a shared drive? So that a group of people could go in and work on it at the same time and save changes? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple users to update the spread sheet at one given time | Excel Worksheet Functions | |||
one sheet-different users, different access to different ranges | Setting up and Configuration of Excel | |||
Prevent users to use a workbook/sheet after a specified day | Excel Worksheet Functions | |||
Add-Ins and Multiple Users on 1 Computer | Excel Discussion (Misc queries) | |||
multiple pages for multiple users | Excel Discussion (Misc queries) |