Organization Only Access
Is it possible to limit the visibility of an excel sheet to only people in our organization? Example: David@FakeCompany.com and David@RealCompany.com both try to open the same excel sheet. The sheet checks for @RealCompany.com and doesn't open for any other option. Does anyone have an idea when the dynamic dropdown functions will be available to us non-adventurous users?
Securing data in excel - how to prevent onward links into unprotected files
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-cells/a791e6f3-9852-4eaa-bb7b-5fac1ea5f80b). 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?