Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating Links from Closed Source Workbooks
Is there anyway to have destination cells update in an open workbook from
source cells in closed workbooks? I have a Summary workbook that contains links to many closed workbooks in the same directory. The closed workbooks also have some links to the open Summary workbook, so that when I make a change to a source cell in the Summary workbook a calculation would be done in the destination cell of the closed workbook and another destination cell in the Summary workbook that contains a link to the calculation result in the closed workbook will update. Thanks, Fred |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating Links from Closed Source Workbooks
For most things you should be able to update automatically. There are some
functions that won't work on a closed workbook - such as a VLOOKUP() that needs to look something up in the closed book. In Tools | Options, on the [Calculate] sheet, make sure that Update Remote References is checked, and you may want to go to the Tools | Options and on the [Edit] tab, clear the Ask to Update Automatic Links checkbox to get rid of the nag. Now obviously the closed workbooks are not going to get the changes made in the open, Summary, workbook - do the same setup in them and at least they'll update when opened. Now, if you set up these inter-workbook links in a way that they become a circular reference kind of loop, all bets are off. "Fred Ernst" wrote: Is there anyway to have destination cells update in an open workbook from source cells in closed workbooks? I have a Summary workbook that contains links to many closed workbooks in the same directory. The closed workbooks also have some links to the open Summary workbook, so that when I make a change to a source cell in the Summary workbook a calculation would be done in the destination cell of the closed workbook and another destination cell in the Summary workbook that contains a link to the calculation result in the closed workbook will update. Thanks, Fred |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating Links from Closed Source Workbooks
So you're using the closed workbook as essentially a calculation sheet?
If that's what you're doing, then nope. You'll have to open the workbook for excel to do that roundabout calculation, er, calculations. Fred Ernst wrote: Is there anyway to have destination cells update in an open workbook from source cells in closed workbooks? I have a Summary workbook that contains links to many closed workbooks in the same directory. The closed workbooks also have some links to the open Summary workbook, so that when I make a change to a source cell in the Summary workbook a calculation would be done in the destination cell of the closed workbook and another destination cell in the Summary workbook that contains a link to the calculation result in the closed workbook will update. Thanks, Fred -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I sort a source file without disturbing the links? | Excel Discussion (Misc queries) | |||
Updating Old Workbooks | Excel Worksheet Functions | |||
How do I automatically update chart source data links for moved fi | Charts and Charting in Excel | |||
How to find cells with links to other workbooks? | Excel Discussion (Misc queries) | |||
XL2003 Destination and Source Open but not updating | Excel Discussion (Misc queries) |