Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Montreal, Quebec
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sharing a workbook - your experience (Office XP)

    Hi gang,
    I was thinking about sharing a workbook in the department and was wondering if you would recommend it.
    I read the help about sharing a worbook and them don't mention limitations like how many person can make modifications at the same time.
    Could someone share their experience with me or point me to explanations more detailed than what Help can give me.
    tks.
    Johanne Champagne
    Montreal (Quebec) CANADA

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

    Re: Sharing a workbook - your experience (Office XP)

    I strongly recommend *not* sharing a workbook. It is a recipe for corrupting the workbook sooner or later.

    With a 'normal' (non-shared) workbook, users can still view the workbook in read-only mode while someone else is editing it, and they can indicate that they want to be notified when the workbook is available for editing again.

    If you really need multi-user capability, think about a database program such as Access or SQL Server.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sharing a workbook - your experience (Office XP)

    I agree with Hans. If I had any say in this I'd send out the next Office update with a "fix" that makes sharing workboks impossible.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

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

    Re: Sharing a workbook - your experience (Office XP)

    My experience is that shared workbook become corrupted very frequently. If you must share a workbook, I would recommend backing it up every couple of hours and keep ALL of the backups so you can work back until you find one that is not corrupted.
    Legare Coleman

  5. #5
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Montreal, Quebec
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sharing a workbook - your experience (Office XP)

    I decided to go with your advice and not share the workbook.
    Thanks for your help.
    Johanne Champagne
    Montreal (Quebec) CANADA

Posting Permissions

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