Open a Spreadsheet for exclusive use

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I have 2 people that use the same spreadsheet and I need
to set it up so that when one has it open the other
cannot write to it until it is closed.

Anyone know how to do that in Excel? Version 2000 or
2002.
 
Dan said:
I have 2 people that use the same spreadsheet and I need
to set it up so that when one has it open the other
cannot write to it until it is closed.
Click to expand...

If these two users are accessing the file from the same location on the same
server, this is how Excel always works. The first user to open the file in
Excel gets a write lock on the file. Other users can open the file
read-only, but can't modify the file.

If your users would be accessing different copies of the same file but on
different servers, it'd be MUCH HARDER to manage this sort of access.
 

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

Excel Excel spreadsheets opening at top instead of bottom. 4
Open One Spreadsheet from Another 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Lookups - how to obtain data from a master spreadsheet into another 5
2003 database opening as Exclusive in 2007 3
Linking spreadsheet 1
error with countif formula on when adding linked spreadsheets 0
Scrabble Value calculation for Welsh words 0

Back
Top