Linking Excel Worksheets

dezinsektor

New Member
Joined
Sep 30, 2019
Messages
16
Hi everyone,

is there a way to connect 3 different Excel workbooks so if I change a set of data in one workbook, the changes are visible in other 2 workbooks and vice-versa?
And is it possible to do it in a way that I don't need to open all 3 workbooks at the same time?

Thank you.
Cheers!
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

dezinsektor

New Member
Joined
Sep 30, 2019
Messages
16
Let me explain it little bit more to be clear what I'm trying to do here. So basically I have 3 identically structured Workbooks, and one table inside of each one is the same table, same sheet and same cells.
Inside that table is a set of data which are input for another software which is triggered by a macro. Those inputs change over a time and I want to be sure that every time this change is made that this is done in all workbooks. Sometimes I use only one workbook (lets call it Workbook 1) for some period of time and can easily forget that this set of data is changed, so when I open workbook 2 I will have wrong (obsolete) inputs.
 

dezinsektor

New Member
Joined
Sep 30, 2019
Messages
16
And sometimes I use Workbook 3 for some period time and when changes are made (in that specific table) I want to be sure that is also done in Workbook 1 and 2.
 

Watch MrExcel Video

Forum statistics

Threads
1,126,994
Messages
5,622,053
Members
415,875
Latest member
Tarali

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top