View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
working working is offline
external usenet poster
 
Posts: 8
Default Excel document incorrectly applying read-only

Hi Alan
thanks for this tip as I didn't know you could access info that way.

Unfortunatley the options are all showing as blank (no password applied).

very puzzling/frustrating

thanks
Sue

"Alan" wrote:

I don't know if you've already tried this. Open the file and click 'File' on
the toolbar, 'Save As'
On the right hand side of the dialogue box that opens, click 'Tools'
'General Options'
If there's anything in 'Password to Open' or 'Password to Modify', remove it
and save the file. You'll get the 'This file already exists' message, Click
yes to save.
Regards,
Alan.
"working" wrote in message
...
Hi

I have an excel document that needs to be modified by any user. When the
doucment is opened on other computers it is incorrectly defaulting to read
only.

I have check the following areas and all have the following settings
Excel
Tools Protection - none applied
Tools Options Security - none applied
File Permissions - unrestricced access

Explorer
r/m/c on document
Properties General Attributes - none applied (I tried to set for
read-only
applied, then unticked read-only, apply - still opens on other computers
as
read-only)
Properties Security - Permissions for everyone = Full Control

I have obviosly applied something? somewhere? that is forcing the
"Read-Only" properties for other users.

Any suggestions welcome

thanks
Sue