In excel,how is it possible to link two files so that the data get updated when data in other file is changed?

Answer 1

If you have selected the "Update Remote References" In
Tools > Options > Calculation
Then
you just need to press "F9" and all links you have, will be updated

Enjoy my profile, I am the VBAXLMan

Answer 2

The tables must be joined by a key field. Table A can contain a customer ID field and Home Address data. Table B can contain a customer ID field and Shipping Addrsss data. You do a join between the two tables by the key field customer ID. When you do an Update to Table a to the Address field, you can then have your SQL statement update both Address fields where Customer ID = Cust ID.

Example:

Update TableA as a, TableB as b
Set a.Address, b.address = New Address
Where (a.CustomerID = 1234) AND (a.CustomerID = b.CustomerID)

Answer 3

First of all, open both of the files.

Method 1:
Copy the data you want, switch other file and
"Edit" -> "Paste Special"
Select "Paste Link" lower left, then OK.
Then look at the copied cell, formula is linked to orginal file.

Method 2:
Select cell, write =
Then go to original file, select the cell you want, then just press Enter.
Reference value comes to your cell.

Answer 4

It is possible. But not a good idea. Both files have to be present for the other to be updated. The precedent file should not be accidentally substituted, renamed, or move to another location. The precedent cell should not move to another cell address.