Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links do move when a row is added
I have a spreadsheet where multiple rows may be added during the month, but
the linked spreasheet does not recognize this change. I was wondering if there is a way to either: 1. have the links update automatically 2 or have the linked spreadsheet open automatically when the first spreadsheet is opened. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links do move when a row is added
Hi Dana,
If your links are to cells that have new data added ahead of them (eg a 'Totals' row), then naming those cells and linking to the named ranges will resolve the issue. Cheers -- macropod [MVP - Microsoft Word] "Dana" wrote in message ... I have a spreadsheet where multiple rows may be added during the month, but the linked spreasheet does not recognize this change. I was wondering if there is a way to either: 1. have the links update automatically 2 or have the linked spreadsheet open automatically when the first spreadsheet is opened. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One or More Links cannot be updated Error | Excel Discussion (Misc queries) | |||
updating links | Excel Worksheet Functions | |||
Excel 2003 Opens Excel 97 Files & recalcs links | Excel Discussion (Misc queries) | |||
Reoccurring Edit Links Error | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) |