Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links between sheets in error due to insert rows
I have links set up between a number of complex worksheets and workbooks in
excel 2003. However, I find that when I insert rows or columns in the sheet to which I'm linking, it throws off the value in the linking sheet. In workbook #1, I have link <=[workbook #2.xls]worksheet!$B$10 If I go to Workbook #2 and insert a row or rows above row 10, the value shown in Workbook #1 changes, because it is showing the new value in cell B10. However, what I want to be able to do is link to the particular cell in workbook #2 - so that I could insert and delete rows/columns, and the info in that particular cell would still be the source of the link. Thanks, Sarah |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Rows in Balance Sheet Template | New Users to Excel | |||
It is some functions who insert rows? | Excel Worksheet Functions | |||
Insert Multiple Rows | Excel Discussion (Misc queries) | |||
Insert a number of rows based on a value in a cell on active row | Excel Discussion (Misc queries) | |||
Exact rows, multiple sheets | Excel Discussion (Misc queries) |