Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
External workbook links don't update when source file changes
HELP! I have a workbook containing links to a worksheet in another workbook.
The source file contains various totals that change each day as I add rows with additional numbers. Every time I revise the source file, and the cells containing the totals move to different locations, the values in my destination file turn to 0. The links in the destination file do not see the totals in their "new addresses" - and I have to manually create new links each time. I assume this has to do with absolute vs. relative but nothing I try is working! HELP! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
External workbook links don't update when source file changes
If all else fails, assign a Named Range to the link points. They will track
the correct cells even if you add/remove rows/columns: something like: ='E:\Book2.xls'!alpha instead of: ='E:\[Book2.xls]Sheet1'!$A$2 or ='E:\[Book2.xls]Sheet1'!A2 -- Gary''s Student - gsnu200814 "Lori Lynn" wrote: HELP! I have a workbook containing links to a worksheet in another workbook. The source file contains various totals that change each day as I add rows with additional numbers. Every time I revise the source file, and the cells containing the totals move to different locations, the values in my destination file turn to 0. The links in the destination file do not see the totals in their "new addresses" - and I have to manually create new links each time. I assume this has to do with absolute vs. relative but nothing I try is working! HELP! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Links in Excel 2007 with variable source file | Excel Worksheet Functions | |||
how can i update links in destination workbook when source workbo. | Excel Worksheet Functions | |||
Cannot find source of external workbook links | Excel Discussion (Misc queries) | |||
Links only update when external workbook is open | Excel Worksheet Functions | |||
** Links don't update UNLESS source file is open | Links and Linking in Excel |