Re: Linking workbooks

I am not sure from your comments whether you have one file accessible from
two computers or two copies of the files on separate computers.

One file accessed from two computers
It is bad practice to have a file available for update by more than one
person which is why, by default, any other user will be locked out. Whilst
it may be inconvenient for one person to be locked out of a file having both
users trying to update the same record would produce a muddle.

Two files on separate computers
Having two copies of a file means that you can both access data
independently but, at the end of the day, you now have two files with a
mixture of updated data which should now be merged.

I hope I have adequately covered your query.

Regards.

Bill Ridgeway
Computer Solutions

"lobo" <mbentler@xxxxxxxxxxxx> wrote in message
news:1148489428.351804.24320@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi, I have two workbooks, exactly the same, on two different computers
and both have to be updated. Updating takes place by two different
people. My problem is that when I try to update the one on the other
computer, the user has left it on and I get a read only file and vice
versa when he tries to update mine.
We both need this file at varying times of the day, sometimes at the
same time. Is there anyway that I can link these two files so that as I
input data or he inputs data, both files are updated?
Thank you



.

Relevant Pages

  • Re: Which programmable task can be done faster by a human than by a computer?
    ... >> for processing of the input data is not exactly known, ... > it's NP-complete or whatever hardness class, computers will solve them ... Even if it seems to be similar, playing chess and go is absolutely not the ... it (even able to beat the best human players) while go require a lot of ...
    (comp.theory)
  • Linking workbooks
    ... Hi, I have two workbooks, exactly the same, on two different computers ... Updating takes place by two different ... We both need this file at varying times of the day, ... input data or he inputs data, ...
    (microsoft.public.excel)
  • Re: How much memory for C program ?
    ... and system specific in nature. ... And, of course, depends on the input data. ... "It is important to remember that when it comes to law, computers ... Only people can be given permission." ...
    (comp.lang.c)
  • Re: Which programmable task can be done faster by a human than by a computer?
    ... skip here from consideration any tasks where the computation algorithm for processing of the input data is not exactly known, so it can't be programmed to achieve same result as when the task is given to a human). ... Once the algorithm is known and at least implementable on a Turing-type machine, then even if it's NP-complete or whatever hardness class, computers will solve them faster than us. ...
    (comp.theory)
  • Vba - Log in user name
    ... I get the "Computers name" ... how can I get the actual logged in user in the network? ... can input data into the same excel file on the same time? ...
    (microsoft.public.excel.programming)