Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    Unable to access file in read-only mode?

    Hi everyone, this is a general question because I'm not sure exactly what is causing the problem. Sometimes I feel like I'm fighting a losing battle!

    This is Excel 97.

    I setup an activity tracking application in Excel in which several users (about 30) each input their daily productivity into seperate workbooks (everyone has their own file named "AT [user_number].xls"). All of the files in this system are located in a single directory on the LAN (NT Server). On start-up, each workbook links to a central workbook called "User List.xls" that lists all the users. The links are simple VLOOKUPs that return the users' names and wages, etc depending on their user number.

    This always appeared to work fine (it has been in operation since August 2000) until about a month ago when LAN performance issues appear to have created some speed issues. Now, many times users will get the message "Unable to access User List.xls" when this linking occurs.

    I was under the impression that when Excel opens a file to update links that this operation is read-only. If two people are trying to access the same file as read-only, why would either of them get a network error message like that? Or is this internal to Excel 97?

    Has anyone had any experience with this type of error?

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Brisbane, Queensland, Australia
    Thanked 1 Time in 1 Post

    Re: Unable to access file in read-only mode?

    No answer to the why, but a possible workaround is to make User List.xls read only (file attribute). This may make it faster anyway.
    David Grugeon
    Brisbane Australia

Posting Permissions

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