Forum Discussion
Solved
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 eac...
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.
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.