Solved

Excel "the folder is marked as read-only"

Posted on 2013-05-22
3
580 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

How to set-up an On Demand, IPSec, Site to SIte, VPN from a Draytek Vigor Router to a Cyberoam UTM Appliance. A concise guide to the settings required on both devices
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 how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

707 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