Solved

Excel "the folder is marked as read-only"

Posted on 2013-05-22
3
569 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Let’s list some of the technologies that enable smooth teleworking. 
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

680 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