Linked Workbooks on Different Computers

[DMan2014]

I have 4 linked workbooks in the same folder stored on a network accessible by a number of computers. Three of the workbooks (I will refer to them as Input1, Input2 and Input3) are used to enter raw data (e.g. votes for a particular item); the fourth workbook (I will call Consolidation) takes the data entered in the three input workbooks and creates a real time count of votes for each item). When operating on the same computer all of the links function properly. The Consolidation workbook records the information as it is entered -- no muss, no fuss, no problem. Unfortunately, I don't want everything to operate from just one computer. I want each of the input workbooks to be on a separate computer, and the consolidation workbook on a fourth computer. Unfortunately, when I try to have the Consolidation workbook operate from a second computer no updates are made as new data is entered. Is there a way to fix this problem?

Thanks in advance.

[playaller]

Excel was not really created for multi user access which is why it acts up over networks in those situations. There may be a workaround that you can try.

Share each of the workbooks.
Create a new module and Place the subs in each workbook to be updated.
Update the seconds to how long to wait to update the workbook being viewed
Update "TheSub" to the the name that the second sub if changed to or other sub inserted to if there is one.
Update "\\rexzhang-pc\d\test_dde_.xlsx" to the network address to the file needing to be updated. (You can add multiple lines of that line to represent all files connected to.
You'll need to run the second sub (TheSub) or call it from a button or another macro to start the timer.

Please Login or Register  to view this content.

Can be kept as is or included within another sub. (Ifin another sub rename the reference in the above sub)

Please Login or Register  to view this content.

[DMan2014]

Thanks for the tip. I will give it a try (may get back to you for some help in doing so), and let you know if it works for me.