| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I get linked data to update inserted rows
I have two workbooks that are linked. If I add a row in my source workbook
and update the link in my destination workbook, the new row does not show up. (I will need to be able to see new columns added to the source as well) Is there a way to paste link and update these types of structure changes? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I get linked data to update inserted rows
Same answer as over in the programming group.
You will need VBA to automatically insert the rows/columns into the target workbook. Gord Dibben MS Excel MVP On Fri, 30 Mar 2007 13:40:02 -0700, Jean-Toledo wrote: I have two workbooks that are linked. If I add a row in my source workbook and update the link in my destination workbook, the new row does not show up. (I will need to be able to see new columns added to the source as well) Is there a way to paste link and update these types of structure changes? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I get linked data to update inserted rows
Thanks - I didn't know where to post this questions for sure.
"Gord Dibben" wrote: Same answer as over in the programming group. You will need VBA to automatically insert the rows/columns into the target workbook. Gord Dibben MS Excel MVP On Fri, 30 Mar 2007 13:40:02 -0700, Jean-Toledo wrote: I have two workbooks that are linked. If I add a row in my source workbook and update the link in my destination workbook, the new row does not show up. (I will need to be able to see new columns added to the source as well) Is there a way to paste link and update these types of structure changes? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked data tables wont update automatically | Excel Discussion (Misc queries) | |||
| how do you get a formula to not update when rows are inserted | Excel Discussion (Misc queries) | |||
| Formula doesn't update when rows are inserted | Excel Worksheet Functions | |||
| insert rows and update linked cells | Excel Discussion (Misc queries) | |||
| automatic update of filtered linked data? | Excel Discussion (Misc queries) | |||
Linear Mode
