asdafgafawaaa
New Member
- Joined
- Jun 23, 2017
- Messages
- 19
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 ='[Test2.xlsx]1'!A1
Thank you in advance!
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 ='[Test2.xlsx]1'!A1
Thank you in advance!