Forum Discussion
Link to external sheet
Hello to all, having regard to the simplicity of removing security passwords to an excel file, I am looking for a system to link a price matrix to a configurator so that the user can use it without ...
If you give the link to the sheet in another workbook you actually give end user access to all data in that sheet. The only to do is copy/paste such link into blank sheet, better on same position, make relative reference in the link and drag that cell around.
I don't think that's more reliable than password protection. All depends on end user skills.
Dear SergeiBaklan, thanks for your reply.
it too laborious using the solution you suggested. However, just for my test, I did a password removal without any 3rd party tools, it took like 3 minutes.. is not the reasonable security level that I need 🙂