Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Inserting rows in source workbook
Excel 2003 - I have 1 source workbook that contains prices of items used in
recipes. Hundreds of recipe workbooks are linked to this source workbook. I need to insert rows, but I don't want to open all 100+ linked workbooks. If I insert a new item in the source, all recipe workbooks now look at the wrong information. Any suggestions? |
#2
|
|||
|
|||
How are they linked? To specific cells in the source book, or do they use a
Lookup formula, or something else? A little more info, if you please? "IrishAnne" wrote: Excel 2003 - I have 1 source workbook that contains prices of items used in recipes. Hundreds of recipe workbooks are linked to this source workbook. I need to insert rows, but I don't want to open all 100+ linked workbooks. If I insert a new item in the source, all recipe workbooks now look at the wrong information. Any suggestions? |
#3
|
|||
|
|||
Absolute reference to specific cells in the source book.
"Duke Carey" wrote: How are they linked? To specific cells in the source book, or do they use a Lookup formula, or something else? A little more info, if you please? "IrishAnne" wrote: Excel 2003 - I have 1 source workbook that contains prices of items used in recipes. Hundreds of recipe workbooks are linked to this source workbook. I need to insert rows, but I don't want to open all 100+ linked workbooks. If I insert a new item in the source, all recipe workbooks now look at the wrong information. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating master workbook from source that may/may not exist | Excel Worksheet Functions | |||
inserting rows through external data source | Excel Discussion (Misc queries) | |||
Winn98SE, Excel2000: ODBC query opens the source workbook | Excel Discussion (Misc queries) | |||
Using Excel workbook as data source for word mailmerge | Excel Discussion (Misc queries) | |||
Inserting Multiple Rows with Formulas | Excel Worksheet Functions |