can two people work on the same worksheet from different computer

M

Marci

We are entering info in a worksheet. Can two employees enter info into the
same worksheet (at the same ) working from two different computers? Or will
opening the worksheet by employee #2 be a "read only" (while employee #1 has
the worksheet open) if this is possible, how do we proceed?
 
T

T Tipsy

Yes you can have multiple people working in the same file. The steps to do
this will vary a little depending on your version of EXCEL. You can get
started by looking up 'Share Workbook' in HELP.
 
G

Gord Dibben

You can share the workbook under Tools>Share Workbook.

Note you will lose quite a bit of functionality when you share a workbook.

See help on Features that are unavailable in shared workbooks


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

linking different worksheets in a workbook for a formula 1
Delete duplicate rows of data when two columns are the same 6
Compare data from two different worksheets with a condition 2
How do I filter data from a master worksheet to other worksheets 1
Entering information from 1 worksheet to another, if criteria is m 8
Pulling data from another worksheet 2
merge data from one worksheet to another 1
Excel Referencing one cell from a different worksheet and slide in powerpoint 0

Top