Saturday, August 21, 2010

How do I keep source data private in microsoft excel?

I have a workbook that I need to forward. It has several sheets of data but I want the email recipiant to only be able to see one sheet and not to be able to view the rest of the workbook. How do I keep the recipiant from fishing for my source data? Much Thanks!How do I keep source data private in microsoft excel?
Password protect each sheet you want to protect, hide those sheets, then password protect the sheet you are sharing and hide the formulas.

No comments:

Post a Comment