Problem with multiple users opening a workbook

D

Dazza13

We have a workbook in 97-2003 format, the problem is that 2 users are able to
open and make changes to the workbook even though it is not shared out.

What we require is that if one person opens it then the second will get the
message that it is open and to open it as read only but this is not happening.

One user is using excel 2003 and the other is 2007 I don't know if this
makes any differnece. I have tried saving as html and the saving back as a
workbook but this has had no effect.
 
D

Dazza13

They both open the same copy on the network i'm not sure what you mean by set
to edit the local copy?
 
B

Bob I

Sorry, I was remembering a setting in Word 2007. "Copy remotely stored
files onto your computer and update the remote file when saving"
 

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

Merge Multiple workbook sheets into one workbook 0
Multiple users with Excel workbook 5
Some users not able to open excel shared workbook 2
corrupted shared excel workbook 1
Problems opening Workbook 1
Shared workbooks 2
force excel workbook to open to a specific worksheet 1
Close form automatically upon opening workbook 2

Top