Home

Securing data in excel - how to prevent onward links into unprotected files

%3CLINGO-SUB%20id%3D%22lingo-sub-327973%22%20slang%3D%22en-US%22%3ESecuring%20data%20in%20excel%20-%20how%20to%20prevent%20onward%20links%20into%20unprotected%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327973%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20secure%20information%20stored%20within%20an%20excel%26nbsp%3Bfile%2C%20and%20prevent%20users%20from%20extracting%20it%20in%20bulk.%20It%20seems%20possible%20to%20disable%20the%20cut%20or%20copy%20functions%26nbsp%3Busing%20VBA%20(e.g.%20%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fdisable-copycutpaste-function-for-unlocked-cells%2Fa791e6f3-9852-4eaa-bb7b-5fac1ea5f80b%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fdisable-copycutpaste-function-for-unlocked-cells%2Fa791e6f3-9852-4eaa-bb7b-5fac1ea5f80b%3C%2FA%3E).%20Excel's%20protect%20sheet%20functionality%20could%20also%20be%20used%20to%20prevent%20the%20relevant%20cells%20from%20being%20selected%20in%20the%20first%20place%2C%20although%20this%20is%20undesirable%20in%20other%20ways.%20However%2C%20neither%20of%20these%20would%20stop%20someone%20from%20creating%20a%20new%20file%20or%20tab%2C%20linking%20to%20the%20data%20with%20a%20formula%20(e.g.%20%22%3DProtected!A1%22%20etc)%2C%20and%20then%20copying%20the%20data%20from%20that%20unprotected%20location.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20prevent%20other%20files%20or%20tabs%20from%20linking%20to%20the%20data%20I%20wish%20to%20protect%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-327973%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eprotection%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESecurity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Malcolm_Begg
Occasional Visitor

Hi all,

 

I need to secure information stored within an excel file, and prevent users from extracting it in bulk. It seems possible to disable the cut or copy functions using VBA (e.g. https://answers.microsoft.com/en-us/msoffice/forum/all/disable-copycutpaste-function-for-unlocked-ce...). Excel's protect sheet functionality could also be used to prevent the relevant cells from being selected in the first place, although this is undesirable in other ways. However, neither of these would stop someone from creating a new file or tab, linking to the data with a formula (e.g. "=Protected!A1" etc), and then copying the data from that unprotected location.

 

Is there a way to prevent other files or tabs from linking to the data I wish to protect?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies