Hello
When I copy a formula to a new workbook, it will reference to the old workbook. Can you please let me know how to stop that.
PS: the formula is a link between 2 sheets in the same workbook and the new workbook has the same sheets as the old one.
e.g.
Old ='1'!A1
New...