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-Others\Door 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
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-Others\Door 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