Cell linking problem

Mar 7th, 2002, 04:20 AM

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).

Dave Hawley · Mar 7th, 2002, 05:12 AM

Hi

Got a bit lost with all the A's and B's but try going to Edit>Links>Upadate Now.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 04:20 AM	#1
Guest Posts: n/a	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).

Mar 7th, 2002, 05:12 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Got a bit lost with all the A's and B's but try going to Edit>Links>Upadate Now.