G
Guest
Guest
I have a cell in a workbook (lets call it workbook A) containing an OLE link to another application.
I have a second workbook (lets call it workbook B) which contains a cell whose value should be the same as the OLE-linked cell in workbook A (so I've created a link).
The problem I have is that the cell in worksheet B won't automatically update the new value of the cell in workbook A (unless I actually open workbook A first - which I don't want to have do every time) - how can I get round this? (Unfortunately, I cannot link workbook B to the other application - its value has to come from worksheet A).
I have a second workbook (lets call it workbook B) which contains a cell whose value should be the same as the OLE-linked cell in workbook A (so I've created a link).
The problem I have is that the cell in worksheet B won't automatically update the new value of the cell in workbook A (unless I actually open workbook A first - which I don't want to have do every time) - how can I get round this? (Unfortunately, I cannot link workbook B to the other application - its value has to come from worksheet A).
