Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Shared 2010 Excel Workbook

    We have made a network Excel 2010 file Shared. People in the same location as the file server have no issues opening and editing the workbook. People working in another office can see the file on the network server, but cannot open the file to edit.

    Is this a normal activity for Shared files over a LAN?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I can't answer your question, but will comment that sharing files is a notorious way to get a corrupt file. Excel is not really the system to use if multiple people are to open and edit the contents at the same time. Access is more geared towards this, since people are working with the the network file and not working with a copy of the file in their RAM.Steve

  3. #3
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Manchester, United Kingdom
    Posts
    116
    Thanks
    8
    Thanked 17 Times in 16 Posts
    How is the file shared across the wider network? Are all users on the same domain? Check the file permissions on the server. You may find that local users are in the domain users security group and so have write access whereas users in other offices are in another ("rest of world") security group and so have only read access.

  4. #4
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts
    They tell me that all the employees who need to update the file have the same contributor access. They believe that the only difference it that some of the people are at another office. I am not one of the people who has access to the SharePoint site. They just called IT for the answer.

  5. #5
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by iansavell View Post
    How is the file shared across the wider network? Are all users on the same domain? Check the file permissions on the server. You may find that local users are in the domain users security group and so have write access whereas users in other offices are in another ("rest of world") security group and so have only read access.
    There is a test file on our network drive that all the people who should have access can get to. All the people can open the file with no one else in it and save their changes. The issue is that one person cannot open the shared file when others already have it open for edits. He gets the message that the file is open by another user. Why would this one person have issues? All the people are using Office 2010, some are using Windows 7 and others Windows XP. The person with the issues is Windows 7.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •