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?

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?

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?