Excel is Accessing the Data from the Master file which is saved on the Server.

Question

Hi,

We are facing strange issue in excel.
We have created 1 master file on Server with lots data.
Now we have created another excel file to access the data from that master file. if I have server access then only i can see the data locally. if i didn't have the access of the server then instead of that data excel should show me (#N/A). but the problem is people who didn't have the Server Access can easily see that data in Local Excel file.
the Formula is =VLOOKUP(L20,'T:Extra-OthersDoor Working[Door Master List (version 1).xlsx]Combined Master List'!$J:$Q,5,FALSE).
Now i just want to know why this is happening. & how can i prevent the data Breach from server.
Thanks & Regards.
Kailas Bairagi

Excel 正在訪問服務器上保存的主文件中的數據。