RE: Connecting Files

Tech-Archive recommends: Fix windows errors by optimizing your registry

I don't think you read my question properly. I'm not opening the same file,
I'm opening 2 separate files. File2 gets data from File1. I don't get a
"read only" message. What I want to know is, how do I get File2 to update
automatically when File1 data is changed.

"Joel" wrote:

The answer is no on windows. When a file that is already is opened in
windows gets opened by a 2nd person the 2nd person gets a read only file that
is a copy of the file and not the original. the 2nd file cannont write back
to the original file location.

If you used Access instead of Excel then when the file is opened by two
people and the file is set to shared mode then when one person updates the
data the 2nd person also gets the changes.

"Doug" wrote:

I have 2 files, File2 gets data from File1. I used a formula in file2
=X:\Folder\[File1.xls]Totals'!$D$2. If both files are open on the same
computer, File2 updates automatically when data in File1 is changed. If I
open File2 on another computer I get a window that asks to "Update File". I
click OK and the file opens with the correct information, however it doesn't
update if data on File1 is changed after File2 is open.

Is there a way to have File2 update automatically when File1 is changed?

Thanks for your help.
Doug


.

Relevant Pages

  • RE: Connecting Files
    ... The answer is no on windows. ... to the original file location. ... File2 updates automatically when data in File1 is changed. ... click OK and the file opens with the correct information, ...
    (microsoft.public.excel.misc)
  • Connect Files
    ... I didn't get any good response so ... File2 updates automatically when data in File1 is changed. ... open File2 on another computer I get a window that asks to "Update File". ... click OK and the file opens with the correct information, ...
    (microsoft.public.excel.programming)
  • Connecting Files
    ... File2 updates automatically when data in File1 is changed. ... open File2 on another computer I get a window that asks to "Update File". ... click OK and the file opens with the correct information, ...
    (microsoft.public.excel.misc)
  • RE: Connecting Files
    ... The automatic recaulate feature of excel. ... to the original file location. ... File2 updates automatically when data in File1 is changed. ... click OK and the file opens with the correct information, ...
    (microsoft.public.excel.misc)
  • Re: xr-hyper, memoir, and titleref
    ... xr-hyper has not been updated since 2000 ... a link and the link does work (opens the external pdf from file1, ...
    (comp.text.tex)