Past Link

A

Anagh

If I past link one excel cell to another cell in a different fil
The changes in File1 is automatically refreshed in File2 if both the files are opened in the same machine

But if I one File2 in a different machine .. the changes does not automatically refresh ..
How can I do this so that the data is automatically refreshed in File2 even if File2 is opened from a different machine
 
D

DDM

Anagh, this can only be done so long as File1 resides on a shared resource,
such as a network drive or shared folder, that File2 can access. Otherwise,
File1 would have to follow File2 onto the other machine (by being copied
from a floppy, for example), and you would have to change the source of the
link (Edit > Links > Change Source) to reflect the new location of File1.

--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com


Anagh said:
If I past link one excel cell to another cell in a different file
The changes in File1 is automatically refreshed in File2 if both the files
Click to expand...
are opened in the same machine,
But if I one File2 in a different machine .. the changes does not automatically refresh ...
How can I do this so that the data is automatically refreshed in File2
Click to expand...
even if File2 is opened from a different machine
 
A

Anagh

The file are in my network share accessible to both machines.

But it does not automaticaly refresh the data ..

It happanes if both the files are opened in the same machin

----- DDM wrote: ----

Anagh, this can only be done so long as File1 resides on a shared resource
such as a network drive or shared folder, that File2 can access. Otherwise
File1 would have to follow File2 onto the other machine (by being copie
from a floppy, for example), and you would have to change the source of th
link (Edit > Links > Change Source) to reflect the new location of File1

--
DD
"DDM's Microsoft Office Tips and Tricks
Visit us at www.ddmcomputing.co


Anagh said:
If I past link one excel cell to another cell in a different fil
The changes in File1 is automatically refreshed in File2 if both the file are opened in the same machine automatically refresh ..
How can I do this so that the data is automatically refreshed in File
Click to expand...
even if File2 is opened from a different machin
 
D

Dave Peterson

Excel won't "push" the updated value into a closed workbook.

But when you open the other workbook, you'll be asked if you want to update your
links. If you say yes, then the value will be updated.

There's actually a setting within excel that allows you to control this prompt.
If you have that set to ask, you'll be prompted--if you have it set for
automatic, you won't even be asked--it'll just update.
 
A

Anagh

Thanks Dave

But I want to push the data when both the files are already open .. and File2 is opened in a different machin
It is not happenin

----- Dave Peterson wrote: ----

Excel won't "push" the updated value into a closed workbook

But when you open the other workbook, you'll be asked if you want to update you
links. If you say yes, then the value will be updated

There's actually a setting within excel that allows you to control this prompt.
If you have that set to ask, you'll be prompted--if you have it set fo
automatic, you won't even be asked--it'll just update.

Anagh wrote
 
D

Dave Peterson

If there's a link between the two workbooks (File2 has a formula that returns a
value from a cell in File1), the the user of File1 has to save the workbook
(File|Save will do it--no need to close it).

The user of File2 can do:
Edit|links|Update Values

whenever they want to refresh the values.
 
Top