Secure Information
 

I've gone through the archives here, and I think I know the answer, but I
thought I'd ask just to make su

I have a spreadsheet which is shared across a corporate network. Users input
a lot of raw data which managers crunch to get confidential stats which most
users should not be allowed to see. I know that Excel security is very weak,
so I've been saving the shared workbook to my hard drive under another name,
unsharing it, appending the formulas to crunch the numbers, and sending this
workbook out to managers via email.

This is highly cumbersome. I've tried linking a workbook that does the
computation to the original, raw-data workbook, but the location of this
workbook would be easily revealed to any users who knew Excel even a little.
(And linked books are always hard to keep "in sync" with the original
workbook, whose form updates periodically.)

From the posts on this site I kind of think I'm stuck with the yucky
compromise I've outlined above. But does anyone have any suggestions on how
to have a sheet that would be inaccessible to unauthorized users in an
otherwise public workbook? Are there any add-ins out there that would help,
or programs my department could invest in that would work with Excel (not
replace it) to do the job?

Again, I know I'm hosed--but I had to ask. Thanks!

Michael Link