Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Links
Hi,
I have a database spreadsheet with over 100 links to 100 seperate workbooks. Everything is working fine until I insert a row, then all the referrance points become misaligned. It has just been suggested that i uncheck the "update remote referances" box. Before I do this to all my associated workbooks I thought I would ensure that this works, and that it maintains the links Thanks in advance for your help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Links
How about making a couple of small workbooks and testing it?
Are these links that something like: ='C:\My Documents\Excel\[book4.xls]Sheet1'!$A$1 (Pointing directly at a cell) If they are, maybe you can open all the workbooks that depend on that workbook before you make your change. Or you could use a range name in the "sending" workbook. Then refer to that range name in the other workbooks? Or maybe you could create a dedicated worksheet that is used for linking. This sheet accumulates all the links in a layout that doesn't change. The formulas would point back to cells in that same workbook, so that they would adjust if those other worksheets change. But the external workbooks would still point at this one accumulator worksheet. (And hide that worksheet if you want to.) Phin wrote: Hi, I have a database spreadsheet with over 100 links to 100 seperate workbooks. Everything is working fine until I insert a row, then all the referrance points become misaligned. It has just been suggested that i uncheck the "update remote referances" box. Before I do this to all my associated workbooks I thought I would ensure that this works, and that it maintains the links Thanks in advance for your help -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
Excel links | Excel Discussion (Misc queries) | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
can't update links...can't find links | Excel Discussion (Misc queries) |