Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links - Excel 2003
I have 2 workbooks. Workbook A has links to workbook B.
The same field in workbook A is frequently updated. Is it possible to link to a new cell in workbook B each time the field in workbook A is updated? Or does the Link have to override the data in workbook B? Thanks for your help! TW |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links - Excel 2003
You want to update a value in either workbook and have the other workbook get
the same update? If you use formulas, this would cause a circular reference. Kind of like putting =a1 in B1 and =b1 in A1. On top of that, if you type in the value, then the formula will be replaced with the link. Terence wrote: I have 2 workbooks. Workbook A has links to workbook B. The same field in workbook A is frequently updated. Is it possible to link to a new cell in workbook B each time the field in workbook A is updated? Or does the Link have to override the data in workbook B? Thanks for your help! TW -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links - Excel 2003
On top of that, if you type in the value, then the VALUE will REPLACE the LINK.
(sorry) Terence wrote: I have 2 workbooks. Workbook A has links to workbook B. The same field in workbook A is frequently updated. Is it possible to link to a new cell in workbook B each time the field in workbook A is updated? Or does the Link have to override the data in workbook B? Thanks for your help! TW -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Excel Links Updates in 2003 | Excel Worksheet Functions | |||
Excel 2000 to 2003 update links doesn't work properly any suggest | Excel Worksheet Functions | |||
External Links on open and Excel 2003 | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |