Excel workbooks - referencing external cells

[Mike Reed]

I have several workbooks using the same data which is entered in a "source" workbook. All external references work fine until I move, or insert a row in the source workbook - then I have to go to each workbook and re-enter the the source cell. I have tried using $ in the reference, but doesn't work. What am I missing?

[#2 · Accepted solution]

@Mike Reed 

Make sure that all the 'destination" workbooks are open when you insert, delete or move cells in the "source" workbook.

Alternatively, create defined names in the "source" workbook for the cells/ranges you want to refer to, and use these names instead of cell references in the "destination" workbooks.

[#3]

@Mike Reed 

Thank you - it works perfectly when all workbooks are open!