?
Solved

Excel "the folder is marked as read-only"

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

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

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

If you’re involved with your company’s wide area network (WAN), you’ve probably heard about SD-WANs. They’re the “boy wonder” of networking, ostensibly allowing companies to replace expensive MPLS lines with low-cost Internet access. But, are they …
I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

599 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