Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Location
    California, USA
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Max No Users Shared Workbook (2003)

    Is there a maximum number of users that can be sharing a shared workbook at one time?

    We have a shared workbook that was opened by two users and when the third user tried to open it, she got the standard message that the workbook was being edited by so and so, would you like to open it read only. I could understand if there were a lot of users in the workbook, but you would think that at least three could share at one time.

    I searched the Excel help files and the MS support KB as well but this doesn't seem to be documented in the obvious places.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Max No Users Shared Workbook (2003)

    I would avoid using shared workbooks at all. It is not a very stable feature of Excel.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Max No Users Shared Workbook (2003)

    As a working number, I use ONE. <img src=/S/grin.gif border=0 alt=grin width=15 height=15> Excel is notoriously bad at sharing files. However, that said, three should be possible.
    Legare Coleman

  4. #4
    Star Lounger
    Join Date
    Mar 2002
    Location
    California, USA
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Max No Users Shared Workbook (2003)

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    I finaly dug it out of the MS KB. MS claims a max of 256 individuals can have a singel shared workbook open. That would be an awful mess I am sure.

    http://office.microsoft.com/en-us/assistan...aspx?mode=print

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Max No Users Shared Workbook (2003)

    Thom

    Not wishing to labour the point after Hans and Legare's replies but on a purely practical viewpoint, I have seen some horrendous "mistakes" taking place when colleagues share workbooks. Hours of work deleted at a stroke of a key. I even heard of a keyboard been launched across the office at the offender.....My only advise is caution and discipline, any more than 2 and you could have a screen added to the missiles being launched!!!!
    Jerry

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Max No Users Shared Workbook (2003)

    Not to beat a dead horse when the point has already been made more than clear, but shared workbooks are bad. Very, very bad.

    We had more than one file become corrupt that we were using as a shared workbook. After a couple months of losing data and files locking up, we just took turns entering data into the file, or set up separate "data entry" sheets and that info would read into a master sheet, with nothing shared at all.

    Just my <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>

  7. #7
    3 Star Lounger
    Join Date
    Jul 2007
    Location
    United States
    Posts
    220
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Max No Users Shared Workbook (2003)

    I got the whole "DON'T" set up a shared workbook scenario. I was, however, curious at your approach re: "set up separate "data entry" sheets which would read into a master sheet."

    I currently have a project wherein various offices input their data into their workbook and I have a "master" workbook that receives all of those entries via links to theirs. What is the best approach to setting up those "data entry" sheets? How should I set it up to accommodate more than one "data entry" person per office? I have split it up among organizations by just creating other linked workbooks, but would like to know if there is an easy way to delegate it down further and creating more shared access for simultaneous data entry.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Max No Users Shared Workbook (2003)

    Even with separate data entry workbooks, you'd still be limited to one user at a time per office. If more than one person is entering or editing data for the same office, you don't know what the result will be.

    If you really have a need for simultaneous data entry, you should consider using a database instead of a spreadsheet - Microsoft Access for up to 10 people entering/editing data simultaneously, or SQL Server (with an Access frontend) for larger numbers.

Posting Permissions

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