?
Solved

Excel "the folder is marked as read-only"

Posted on 2013-05-22
3
Medium Priority
?
596 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 1500 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

752 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