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?
Password Protecting & Sharing Workbook
Hi, I really need some help. We use a spreadsheet in work to record flexi. The key requirements we need to add are: 1) We are able to lock master cells so that the content, look and structure of the sheets cannot be changed; 2) We are able to track changes and ensure that these cannot be edited or removed (password protect this feature if possible with a master password); and 3) We are able to password protect the wokbooks (with unique passwordd for each user s that they can open and amend the non master cells and reord their times daily. but NOT remove track changes Can someone please help me with advice as to how to set the above 3 functions up? Many thanks in advance, EDeleting rows in a protected sheet in Excel
I am using Microsoft Excel 2016. I created a document, entered data in it and protected it from the review tab. The options that I allowed for anyone who gets access to this worksheet (without unprotecting it) are: 1. Select Locked Cells 2. Select Unlocked Cells 3. Insert Rows 4. Delete Rows The problem that I am facing right now is that when I am trying to insert a row, a new row is inserted, but when I am trying to delete a row, the row is not being deleted. Instead a dialog box appears saying "You are trying to delete a row that contains a locked cell. Locked cells cannot be deleted while the worksheet is protected. To delete a locked cell, first remove protection using the unprotect sheet command (Review Tab, Changes Group). You may be prompted for a password." Am I wrong somewhere? Have I missed something? Please let me know a solution to this.
