Not getting read-only warning

[microsoft.private.mbspartner]

We have users that use the same spreadsheets that are in a shared folder on
our network. The workbooks are NOT set as Shared Workbooks...

Previously, if a user tried to open a spreadsheet that another user had
open, they would receive a warning that they were about to open the file in
Read-Only mode.... but now they are not getting a warning... therefore, two
users may have the file open in read-write mode at the same time... and we
don't want that.

Does anyone know what has happened, and how we can correct it?

 

[Harlan Grove]

We have users that use the same spreadsheets that are in a shared folder on
our network. The workbooks are NOT set as Shared Workbooks...

Previously, if a user tried to open a spreadsheet that another user had
open, they would receive a warning that they were about to open the file in
Read-Only mode.... but now they are not getting a warning... therefore, two
users may have the file open in read-write mode at the same time... and we
don't want that.

Does anyone know what has happened, and how we can correct it?

First make a backup copy of the file in question. Then have user 1 make a
change and save the file. Open the saved file on a 3rd machine to see
whether the change took. Once you've checked, close the file on the 3rd
machine. Now have user 2 make a different change and save the file. Reopen
the file on the 3rd machine and check that the first change has been unmade
and the second change has been made. If so, call Microsoft's paid support
number - you've found a true bug, so you won't need to pay for the call.

However, have you checked whether these multiple users have the file open in
READ-ONLY mode? If you save a workbook with Read-only Recommended (Save
dialog, Tools menu, General Options) AND you set the file's read-only
attribute, then multiple users can open the file READ-ONLY without Excel
displaying the warning dialog that they'd be opening the file read-only.

 

[microsoft.private.mbspartner]

First make a backup copy of the file in question. Then have user 1 make a
change and save the file. Open the saved file on a 3rd machine to see
whether the change took. Once you've checked, close the file on the 3rd
machine. Now have user 2 make a different change and save the file. Reopen
the file on the 3rd machine and check that the first change has been
unmade and the second change has been made. If so, call Microsoft's paid
support number - you've found a true bug, so you won't need to pay for the
call.

However, have you checked whether these multiple users have the file open
in READ-ONLY mode? If you save a workbook with Read-only Recommended (Save
dialog, Tools menu, General Options) AND you set the file's read-only
attribute, then multiple users can open the file READ-ONLY without Excel
displaying the warning dialog that they'd be opening the file read-only.

Just confirming... when you mention "AND you set the file's read-only

 

[Dave Peterson]

I don't think that you even have to save the workbook with readonly recommended
checked.

If the file is marked readonly via its attributes, excel will respect that and
only open the workbook in readonly mode.

To the OP:

In fact, if the permissions changed and the user only had readonly access to the
folder that contained the workbook, then they wouldn't get a message here,
either.

Excel will respect those permissions, too--and open the file in readonly mode
without any prompt.

You may want to see if user with the problem still has read/write/delete
privileges on that share. I'd open NotePad and try to save a .txt file to the
same share to check.


Harlan Grove wrote:

 

[microsoft.private.mbspartner]

Thanks all... will check all that...

I don't think that you even have to save the workbook with readonly
recommended
checked.

If the file is marked readonly via its attributes, excel will respect that
and
only open the workbook in readonly mode.

To the OP:

In fact, if the permissions changed and the user only had readonly access
to the
folder that contained the workbook, then they wouldn't get a message here,
either.

Excel will respect those permissions, too--and open the file in readonly
mode
without any prompt.

You may want to see if user with the problem still has read/write/delete
privileges on that share. I'd open NotePad and try to save a .txt file to
the
same share to check.


Harlan Grove wrote:

 

[Annie Chung]

please tell me how can my worksheets without written 'read only'





microsoft.private.mbspartner wrote:

Not getting read-only warning
29-??-07

We have users that use the same spreadsheets that are in a shared folder on
our network. The workbooks are NOT set as Shared Workbooks..

Previously, if a user tried to open a spreadsheet that another user had
open, they would receive a warning that they were about to open the file in
Read-Only mode.... but now they are not getting a warning... therefore, two
users may have the file open in read-write mode at the same time... and we
don't want that

Does anyone know what has happened, and how we can correct it?

EggHeadCafe - Software Developer Portal of Choice
BASICS: Forms Authentication in ASP.NET 2.0
http://www.eggheadcafe.com/tutorial...33-59a0d69844e8/basics-forms-authenticat.aspx

 

[Bob I]

Please re-phrase the question.