Suhaila
New Member
Hi there,
This is Suhaila. I have a question regarding data that is link from another workbook. During the time when i link the data, the reference shows as Eg: as below
='E:\umm\2018\mytest\excelsystem\dynamic cell ref\[data1.xlsx]Sheet1'!$A$1
however, when the next day i opened the same workbook that i link the data, the reference has changed to -->
='E:\umm\2018\mytest\excelsystem\dynamic cell ref\[$D$3]Sheet1'!$A$1
need help on why this happen and how to overcome this. TQ
This is Suhaila. I have a question regarding data that is link from another workbook. During the time when i link the data, the reference shows as Eg: as below
='E:\umm\2018\mytest\excelsystem\dynamic cell ref\[data1.xlsx]Sheet1'!$A$1
however, when the next day i opened the same workbook that i link the data, the reference has changed to -->
='E:\umm\2018\mytest\excelsystem\dynamic cell ref\[$D$3]Sheet1'!$A$1
need help on why this happen and how to overcome this. TQ