Excel 點樣改格仔裡面link既path?

岩岩整左個Excel template
裡面有好多儲存格係link去同template同一個folder既唔同excel表(e.g. C:/ABC/temp.xls其中一格係C:/ABC/tempA.xls、另一格係C:/ABC/tempB.xls etc.)
我要開三十幾四十個folder裡面既資料係一樣,即係除左上面 C:/ABC, 仲會開 C:/DEF、C:/GHI等等)
咁我裡面D格仔除左手動隨個改path之外
仲可以點改呢

跪求幫手

Step 1. In Book1.xlsx, Formulas -> Name Manager -> New...
Name: ref_book2
Refers to: =[Book2.xlsx]Sheet1!$A:$Z

Don't worry if above seems to be using static path. It'll actually use dynamic path.

Step 2. In any cell in Book1.xlsx, enter formula:
=INDEX(ref_book2, 1, 1)

TOP