Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Oct 2002
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Shared Workbooks (Excel 2002)

    If I am using a shared workbook and it is set up to save changes every 15 minutes how can I go about seeing the changes from other users without closing my file and reopening? Thanks!

  2. #2
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Trenton, Ontario
    Posts
    175
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shared Workbooks (Excel 2002)

    If someone opens up a shared workbook that someone else already has open you can only open it "read only" and no changes can be saved. If the Auto Save is running only the first person can save changes.
    Are you trying to have a read only workbook open and see changes made by the person who is "allowed" to make changes?

  3. #3
    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

    Re: Shared Workbooks (Excel 2002)

    This is NOT true for shared workbooks. It is true if the workbook is NOT-shared (exclusive use only).

    Shared workbooks can be opened and saved by multiple people. If there are conflicts you we be prompted to fix them. As far as I know you can only see the changes others have made when you save (but I don't use shared workbooks)

    Steve

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

    Re: Shared Workbooks (Excel 2002)

    I would like to warn you a bit.

    Sharing workbooks looks like a nice feature, but is poorly programmed into Excel.
    I have seen too many problems reported with shared workbooks loosing data and/or getting corrupted for me to EVER trust and actually use this feature.

    Sharing data is what databases do best.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Lounger
    Join Date
    Oct 2002
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shared Workbooks (Excel 2002)

    Thanks for the confirmation of only being able to see the changes by other users after I have saved, closed and re-opened.

    I agree- shared workbooks sounds appealing however all the limitations take care of that!

    Have a great weekend!

Posting Permissions

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