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]

"microsoft.private.mbspartner" <k...@ceoteams.com> wrote...

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]

"Harlan Grove" <hrl...@gmail.com> wrote in message
news:eW4Ejv0u...@TK2MSFTNGP03.phx.gbl...

Just confirming... when you mention "AND you set the file's read-only
> attribute," I assume you're talking about the read-only attrribute one
> would set from within Windows Explorer? We'll double-check, but I can't
> imagine that one of these users would've changed that attribute... but
> they might very well have saved the file in Excel as Read-Only. Thanks
> for the suggestions.

>
>

[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:
<<snipped>

>
> 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.

--

Dave Peterson

[microsoft.private.mbspartner]

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

"Dave Peterson" <pete...@verizonXSPAM.net> wrote in message
news:4688F8E5...@verizonXSPAM.net...

[anniechung]

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

microsoft.private.mbspartner wrote:

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

EggHeadCafe - Software Developer Portal of Choice
BASICS: Forms Authentication in ASP.NET 2.0
http://www.eggheadcafe.com/tutorials/aspnet/009e2e5e-5a44-4050-8233-59a0d69844e8/basics-forms-authenticat.aspx

[Bob I]

Please re-phrase the question.