Hi,

I think I have a problem with links between workbooks. I hope you can help me. I'll try to explain what I've done:

1) I open two workbooks - the source and the destination workbooks;

2) In the destination workbook I type an equal sign and then select the cells in the source workbook I want to link;

3) Then I have two situations:

First situation: if both workbooks are open, any change in the source workbook is updated to the destination workbook - it works fine!;

Second situation: if I close destination workbook and make a change like "insert rows" in source workbook then when I open destination workbook the cell reference stays the same, it wasn't updated.

Why is this happenning? Is there a solution for this problem?

Thank you