Excel link update# Windows - 看得见风景的窗口
h*n
1 楼
Sorry if this is not the right place for a question about excel.
I need to maintain an excel workbook which contains a lot of links to other
workbooks. Since the linked workbooks change every week, I need to change all
the links accordingly. For example, a cell with formula "='[aug_28.xls]sheet1'
!A10" will be changed into "='[sep_4.xls]sheet1'!A10". I tried to do this with
Find/Replace. However, the value of the cell is updated every time the link
is changed. The link updating takes a couple of
I need to maintain an excel workbook which contains a lot of links to other
workbooks. Since the linked workbooks change every week, I need to change all
the links accordingly. For example, a cell with formula "='[aug_28.xls]sheet1'
!A10" will be changed into "='[sep_4.xls]sheet1'!A10". I tried to do this with
Find/Replace. However, the value of the cell is updated every time the link
is changed. The link updating takes a couple of