Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links error when insert line/row to source workbook
I have a question regarding links on Microsoft Excel 2003.
If I insert a line into the source spreadsheet, the link on the destination spreadsheet doesn't work anymore because the cells moved. The scenario: On the destination spreadsheet, the link is =[ACME.xls]Sheet1'!A1 But if I insert a line on ACME.xls, making the info in cell A1 move down to A2, the link on the destination spreadsheet still pulls from cell A1. How do I ensure that when I insert/delete lines/row, the link still pulls info from the correct cell? Thanks Stella |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links error when insert line/row to source workbook
If you have the workbook with the formula/link open and the Acme workbook open
in the same instance of excel, then excel will adjust those formulas (remember to save when closing). If that's not possible, you could name the cell in Sheet1 of Acme.xls and use that name in your formula. stell88 wrote: I have a question regarding links on Microsoft Excel 2003. If I insert a line into the source spreadsheet, the link on the destination spreadsheet doesn't work anymore because the cells moved. The scenario: On the destination spreadsheet, the link is =[ACME.xls]Sheet1'!A1 But if I insert a line on ACME.xls, making the info in cell A1 move down to A2, the link on the destination spreadsheet still pulls from cell A1. How do I ensure that when I insert/delete lines/row, the link still pulls info from the correct cell? Thanks Stella -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change links to a different source in the same workbook | Excel Discussion (Misc queries) | |||
How can I insert a row in a source that links to a destination | Excel Worksheet Functions | |||
External workbook links don't update when source file changes | 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) |