Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Excel Redaction

Excel Redaction

Excel Redaction

I have a user that wants to remove (redact) information from an Excel spreadsheet (2010), then send that spreadsheet to a third party. They want to be certain that someone at the other end cannot see the information they have deleted.

To be clear: they are not deleting entire rows, they are simply selecting the info in specific cells and hitting the delete key.

After the deletions, they save the spreadsheet and email it as an attachment.

Is this foolproof? i.e. could someone at the other end restore what they have deleted?

RE: Excel Redaction

Deleted data can't be restored in sent file. However, there is a lot of personal data that is or may be stored in the workbook. It may be useful to inspect workbook before sending it. You can see what is kept and how to check it here: https://support.office.com/en-us/article/Remove-hi...
Excel files (.xlsx, .xlsm) are packed sets of xml structures, if you like you can unpack them and view in text editor.


RE: Excel Redaction

Thanks, Combo.

Am I correct that Auto Recover will not revert to a previous version when the file is sent as an attachment?

RE: Excel Redaction

The office file recovery functionality stores files locally, in one of user account folders.


RE: Excel Redaction

Thanks, Combo.

This has been very helpful.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close