Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Missouri, USA
    Posts
    18

    Question Unanswered: real time use of EXCEL file on different PCs

    Is it possible to run an EXCEL file on 2 networked PCs at one time? Like open the file on both PCs at the beginning of the day, allow users to input data throughout the day, and then when it was closed at night it would have any and all changes made on either PC during the day in the one file?

    Thanks in advance.

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Yes, you can but be sure to set it up correctly. Make sure that no one has the workbook open except you when you set it up.

    Tools > Share Workbook > click the diting tab,a nd check the box "Allow Changes by More Than One User at the Same Time". Excel saves the workbook (and recent changes) under the current name. Be sure to specify the location of the file (server) so that the file will be accessible.

    Now in the title bar you will see "Shared" behind the name of the workbook.

    There are some actions you cannot do with shared workbooks:

    Move, copy, delete, or rename worksheets
    Most Property options
    Insert chart, picture, AutoShape, object, or hyperlink
    Insert or delete cells (although you can add/delete rows and columns)
    Merge cells
    Data tools (group, outline, add subtotals, validation rules)
    Conditional formatting or work on scenarios
    A pre-existing PivotTable will work, but you can't create a new one, nor can you change the design of existing one
    Write, edit, or record macros. You can run existing macros, but beware of commands that might be missing.

    ------------------

    Be sure to track changes and change history as well.

    Go to Tools > Share Workbook, and choose Advanced tab; it will give you the option to set how often you want to update the changes (from 5 minutes up to 1440 minutes). You can save it at that interval automatically.

    For tracking, go to Tools > Track Changes > Highlight Changes (uncheck all three options of When, Who, Where)
    Last edited by shades; 04-29-04 at 17:12.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Oct 2003
    Location
    Missouri, USA
    Posts
    18

    Smile

    Thanks so much for the information on how to do this. I also really appreciate your being so specific on how and where to find the commands I need to set.

Posting Permissions

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