Excel linked cells

5 pts.
Tags:
DDE
Dynamic Data Exchange
Microsoft Excel
Object Linking and Embedding
OLE
How can I link two cells on from two different work sheets so that updating info in one will do so in the other and vice-versa? No matter which cell I update I need it to be mirrored by the other cell.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Using OLE (Object Linking and Embedding) or DDE (Dynamic Data Exchange), and setting it to ‘update automatically’, you can achieve this. At any time if the data is changed in source file it gets updated automatically in Destination file (when both are open) or is prompted for update if one is open and changed and other is opened later.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following