Solved

Excel "the folder is marked as read-only"

Posted on 2013-05-22
3
559 Views
Last Modified: 2013-05-23
The company has the following VPN setup...

Server is at main location with 192.168.254.x subnet.
Client is at a satellite location with 192.168.1.x subnet.

Devices can ping/access each other by name all day long.

Server has a shared data drive with the following permissions that are propagated to child objects...

(Domain) Administrators - Full Control
CREATOR OWNER - Full Control
Everyone - Full Control
SYSTEM - Full Control
(Domain) Users- Full Control

Above client receives "the folder is marked as read-only" error when trying to save to a shared folder on the server. If they save the excel file locally, then they can copy the file to the shared folder. Tested that they can create/modify/delete notepad files in the shared folder. Excel seems to be the only program affected.

I should also mention that the Excel file to be saved is generated by a third-party program installed on the client. Program saves the file to client's local drive, file is opened, modified, and can be saved to any location but the shared folder, without error.
0
Comment
Question by:active_datacomm
  • 2
3 Comments
 
LVL 35

Accepted Solution

by:
[ fanpages ] earned 500 total points
ID: 39189475
Hi,

Which version of Microsoft Excel are you using?

In case this helps...

[ http://support.microsoft.com/kb/271513/en-us ]
---
Restricted permissions
When you save an Excel file, you must have the following permissions to the folder where you are saving the file:

    Read permissions
    Write permissions
    Modify permissions
    Delete permissions

Note If you do not have these permissions, the Excel save process cannot be completed.
---

BFN,

fp.
0
 
LVL 35

Expert Comment

by:[ fanpages ]
ID: 39189493
PS. Have you tried using the "takeown" command-line tool to "take ownership" of the file?

---
TAKEOWN [/S system [/U username [/P [password]]]]
        /F filename [/A] [/R [/D prompt]]

Description:
    This tool allows an administrator to recover access to a file that
    was denied by re-assigning file ownership.

Parameter List:
    /S           system          Specifies the remote system to
                                 connect to.

    /U           [domain\]user   Specifies the user context under
                                 which the command should execute.

    /P           [password]      Specifies the password for the
                                 given user context.
                                 Prompts for input if omitted.

    /F           filename        Specifies the filename or directory
                                 name pattern. Wildcard "*" can be used
                                 to specify the pattern. Allows
                                 sharename\filename.

    /A                           Gives ownership to the administrators
                                 group instead of the current user.

    /R                           Recurse: instructs tool to operate on
                                 files in specified directory and all
                                 subdirectories.

    /D           prompt          Default answer used when the current user
                                 does not have the "list folder" permission
                                 on a directory.  This occurs while operating
                                 recursively (/R) on sub-directories. Valid
                                 values "Y" to take ownership or "N" to skip.

    /?                           Displays this help message.

    NOTE: 1) If /A is not specified, file ownership will be given to the
             current logged on user.

          2) Mixed patterns using "?" and "*" are not supported.

          3) /D is used to suppress the confirmation prompt.

Examples:
    TAKEOWN /?
    TAKEOWN /F lostfile
    TAKEOWN /F \\system\share\lostfile /A
    TAKEOWN /F directory /R /D N
    TAKEOWN /F directory /R /A
    TAKEOWN /F *
    TAKEOWN /F C:\Windows\System32\acme.exe
    TAKEOWN /F %windir%\*.txt
    TAKEOWN /S system /F MyShare\Acme*.doc
    TAKEOWN /S system /U user /F MyShare\foo.dll
    TAKEOWN /S system /U domain\user /P password /F share\filename
    TAKEOWN /S system /U user /P password /F Doc\Report.doc /A
    TAKEOWN /S system /U user /P password /F Myshare\*
    TAKEOWN /S system /U user /P password /F Home\Logon /R
    TAKEOWN /S system /U user /P password /F Myshare\directory /R /A
---
0
 

Author Closing Comment

by:active_datacomm
ID: 39190949
Ended up being a permissions issue. Last night, before I left, I threw up my hands and reshared the drive on the server using the same permissions. Checked for all child objects to inherit permissions. This morning, it was all working fine. Weird. I'm guessing that somewhere along the way, permissions were messed up on some of the child objects, and they never inherited the proper permissions back.
0

Featured Post

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Let’s list some of the technologies that enable smooth teleworking. 
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question