Forum Discussion
Excel workbooks - referencing external cells
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?
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.
2 Replies
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.
