vba - Disable any incoming external links to a Excel Workbook -

i have 2 workbooks. test1.xlsx , test2.xlsx , have saved them in same directory.

i write formula create external link in cell a1 of sheet1 of test2.xlsx.

example: in a1 cell of sheet1 of test2.xlsx write =[test1.xlsx]sheet1!a1 , press enter. copies corresponding cell content of test1.xlsx test2.xlsx

i don't want formula executed. want workbook "test1.xlsx" shouldn't accessed other external workbook i.e. no 1 can provide external reference test1.xlsx , if provided, should return error "!#ref"

i using excel 2010.

it quite helpful me know events taking place in test1.xlsx

not behavior requested, this:

password-protect test1. user prompted password when formula entered.

if password correctly entered, formula(s) execute, users prompted password update links each time test2 opened.