Ask Your Question

VLOOKUP in a password protected Workbook...

asked 2017-06-27 10:03:39 +0200

Tarskovsky gravatar image

updated 2017-06-27 10:04:50 +0200

Is it possible to do a VLOOKUP(or any other formula) on a password protected Workbook? Cause I want to let people see some information inside the database(external .ods file), but I don't want them to know all the information or open my database. Maybe using a macro?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-06-27 16:15:52 +0200

Lupp gravatar image

updated 2017-06-27 16:23:54 +0200

If you are talking of a ods-document protected via 'Tools' > 'Protect Spreadsheet---' > 'Protect Document' you can, but the protection is weak.

If you are talking of a document protected by encryption with a password via 'Save As...', 'Save with password' enabled, you can't. Any method to circumvent this would require to use a helper program or routine having access to the pasword used for the encryption in one or another way. And for the working of formulae needing permanent access to data (not only when loading) the encrypted document or a kind of copy of it (probably to RAM) must stay opened.

To be able to manage rights more detailed you will need a full-grown database system,I think. Otherwise you would have to program a lot of tools on your own.

edit flag offensive delete link more


It's not something tooo important, I just want to create my spreadsheet like an interface to show some data to my clients, It will not be a big issue if they crack it. What about a macro to open the password-protected Workbook in the background and then run the VLOOKUP on it?

Tarskovsky gravatar imageTarskovsky ( 2017-06-27 19:41:49 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-06-27 10:03:39 +0200

Seen: 687 times

Last updated: Jun 27 '17