Hi
I have two seperate workbooks, one that has a range of data in several worksheets (source workbook), this is then linked to another workbook (destination workbook).
The linking of the data had been working fine until lately, I believe I know what the problem is I’m just not sure how to fix it.
Recently I added a number of rows to one of the spreadsheets in the data source workbook and now the references/formulas in the destination workbook are out by the number of rows I have inserted.
Could someone advise if there is a way that when I add/remove rows/columns in the source worksheet that the destination workbook will automatically adjust to the new rows/columns.
Thanks in advance for any help
Cheers
Dax