Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Sharing Workbooks (Excel 2003)

    I am aware of how most of the MVPs feel about sharing workbooks. However, I have 15 users that have to get into various workbooks during month closing for editing and viewing, and I do not know what to recommend to them instead of sharing.
    Any ideas?
    Thank you, itconc

  2. #2
    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: Sharing Workbooks (Excel 2003)

    I don't how feasible this is but how about BET: Microsoft Excel Track Changes - Merging Shared Workbooks
    Jerry

  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: Sharing Workbooks (Excel 2003)

    I recommend making the workbook recommended to be read only unless they are going to edit it (part of the options while saving).

    This allows reading it all they want and only requires "edit issues" if more than one needs to update at the same time. If this is a requirement of your database, then I would recommend using something other than excel. Access, for example, works differently and updates the opened file (as opposed to updating the file in memory and rewriting the saved file much later) so is a much better choice for multiple edits in a database.

    Steve

  4. #4
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Sharing Workbooks (Excel 2003)

    Thanks. I know Access works better - I am dealing with 150 accountants and Access is like a foreign language to them.
    itconc

  5. #5
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Sharing Workbooks (Excel 2003)

    Thanks. However, I need something simple - to my users.
    itconc

  6. #6
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Re: Sharing Workbooks (Excel 2003)

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

    Found this product out on the WEB. I don't use it, don't know if it will help, but they do have a free demo you can download.

    http://badblue.com/helpxls.htm

    Regards,

    tom Duthie

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

    Re: Sharing Workbooks (Excel 2003)

    If you need users to be able to edit the workbook simultaneously, you could look at the product mentioned by Tom Duthie (I have no experience with it), otherwise I'd go with Steve's suggestion to make the workbook open as read-only by recommendation. That way, multiple users can view the workbook without much hassle, and someone who needs to edit data can still do that (but only one at a time).

  8. #8
    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: Sharing Workbooks (Excel 2003)

    If the user interface is well written, the accountants should not be aware of what program they are using. All you need is one good access programmer to create the application...

    Steve

  9. #9
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Sharing Workbooks (Excel 2003)

    I agree. However, these accountants work with many spreadsheets and it would be impossible to use Access for each one.

  10. #10
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Sharing Workbooks (Excel 2003)

    Thanks. I think that will be the only answer, although I will test the program mentioned.

  11. #11
    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: Sharing Workbooks (Excel 2003)

    They don't have to use it for all of them, only those that require that multiple people must be edit it any time. If the editing can be done at different times, there is no issue with using excel. They can view it and work with it at any time no matter who has it open - it will be "read only". Only the person editing it at that particular time needs to have the ability to edit and save it.

    They all must be courteous and not leave the editing workbook open so that others can not edit it however and others must be patient enough to allow one to finish editing it, before they get to make their changes.

    Steve

  12. #12
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Sharing Workbooks (Excel 2003)

    If I had considerate users I would be so happy. All of our spreadsheets are treated in a mutli-user fashion.
    Thanks for the input.

  13. #13
    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: Sharing Workbooks (Excel 2003)

    Unfortunately the lack of consideration is generally a problem with anything that is shared in any manner....

    Steve

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

    Re: Sharing Workbooks (Excel 2003)

    <hr>All of our spreadsheets are treated in a mutli-user fashion. <hr>
    Wow. I sincerely hope you have an excellent backup system in place! (and proper procedures to check data and model validity).
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  15. #15
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Sharing Workbooks (Excel 2003)

    We have an ecellent backup system. However, our control systems leave a lot to be desired. We are working on that.

Page 1 of 2 12 LastLast

Posting Permissions

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