Excel links will not update?

[jossari]

Hi,

I am using two excel worksheets at same time named A and B. These both have same visual Basic code for automated betting. I have linked some values from worksheet A to B and vice verca some values from B to A. I am using worksheet A to GAME 1 and worksheet B to GAME 2.

My problem is that automated betting will work only with this worksheet, which is actived or selected. And also these links between worksheets A and B will work only A-->B or B-->A depending which worksheet is actived.

Question: How I can be sure that links A-->B and B-->A will work at same time --> both worksheet are activeted?

I am using "calcGreenUp" code which is introduced in these pages..

BR: AH

[osknows]

Hello,

Links across workbooks only work 'live' if both workbooks are in the same instance of Excel. If you have 2 or more instances open then you have to manually update links in DATA/EDIT LINKS/UPDATE which is probably not what you want.

If you must have more than 1 instance of Excel a workaround is to copy the data you need using VBA using a worksheet_ calculate or worksheet_change event

Os