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! |
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! |
All times are GMT +1. The time now is 09:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com