Locking Excel for Editing

P

pslaught

I have a spreadsheet that is available on a shared drive at work.

I've seen it done before where, once the spreadsheet is open by one person,
everyone else can only open it as "read-only." The first person to open the
spreadsheet has the ability to edit it -- thereby, only one person can edit
the spreadsheet at a time.

How do I do this?

Thanks!
 
D

dlw

doesn't that happen automatically? On your network, can multiple open and
edit one file? That would be odd.
 
H

Harald Staff

Hi

This is default behavior, you don't have to do anything but saving the sheet
on a shared drive.

HTH. Best wishes Harald
 
S

ShaneDevenshire

Hi,

If that's not happening, maybe your workbook is in Share mode. If so take
it out of Share mode by Tools, Share Workbook and uncheck Allow changes by
.....
 

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

Email Date from Excel 1
Excel Spreadsheet 1
Editing cell names 1
row locking, instead of file locking? 2
Multi-user access to Excel 3
Shared workbook access issue 1
Filename is locked for editing in Excel 2002 SP3 1
Conditiontal linking between spreadsheets 3

Top