Solved how to prevent a sent spreadsheet from being forwarded on

August 10, 2013 at 07:24:11
Specs: Windows 7
I am trying to understand how this would work but really have no idea
If I were to send an excel workbook to you, I would need to be sure that you would be unable to forward this on to another party.
How would I go about executing this with a workbook?

I know this is a basic description of what I am trying to do, but the easier the explanation, hopefully the easier the solution

Any ideas?

See More: how to prevent a sent spreadsheet from being forwarded on

August 10, 2013 at 09:02:27
I'm not sure how you could prevent someone from forwarding it without removing their capabilities to disable the internet or ability to send an email without attachments (but they again there is always webmail and so many ways to move files, e.g. dropbox). If you password protect the file, you still have to provide the password to that user, so that doesn't get you very far.

If your worried about someone passing on your data for a business, I would suggest something like spectre360, email archiving, so that way you can prove they shared that file and hold them accountable.

Report •

August 10, 2013 at 17:42:01
✔ Best Answer
DAGS prevent forwarding of email and you'll see hit after hit that explains why you can't stop someone from forwarding an email or at a minimum forwarding the data in the email. You can make it hard, but you can't make it impossible.

As far as the spreadsheet itself, even if they didn't forward it, they could save it and attach it to another email.

Even if you made it viewable only once by including code to erase all the data once it was closed, they'd still have the original copy that they could download, not open (once they realized what was happening) and sent it to someone else.

They could also take a screen shot of the file and piece it back together so that the data could be viewed even if it wasn't in spreadsheet form.

Bottom line: If you don't trust the recipient to follow your instructions and keep the document private, don't send it to them.

Putting the file on a secure server accessible only by those with randomly changing credentials (e.g. RSA SecurID) can be somewhat safer, assuming you don't allow saving of the data to an external system and assuming - ready for this? - you can prevent the user from sharing his SecurID tag and PIN with the bad guys and/or prevent the bad guy from looking over someone's shoulder while they "legitimately" access the file.

Hey, I got it! Store the file on a single standalone system in a locked room and use the most intense biometric security measures possible - retina scans, finger print scans, voice recognition, etc. If you do all that, your data might be safe from being viewed by those that aren't authorized. Good luck!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

August 23, 2013 at 11:07:47
Nice one DerbyDad03, the question was just to see how I would go about selling a little program to the general public without losing out. Its just something I am playing with.

Could be worth a bit if I can get it right, so we will see.

Great response though, this retina thing, hows that work????????

Going to post a query, if you could look out for it. I think I have seen an answer before but can not seem to find anything near what I am after

Report •
Related Solutions

Ask Question