securing sensitive data/formulas

eparucki · Mar 6th, 2002, 07:55 AM

I am currently trying to create a way to do the following:

* have a user enter data on one worksheet
* have that data manipulated in another spreadsheet (utilzing worksheets there, static data, formulas, etc...)
* then have those calculations appear on the original spreadsheet

The goal here is to not allow the users to see or manipulate the data/formulas in the second spreadsheet.

I have all the data and the formulas done, but I cannot seem to achieve the goal of not having the users see the data/formulas.

Any suggestions??

TIA!!

lenze · Mar 6th, 2002, 08:12 AM

Activate the sheet you don't want users to see and choose Format>Sheet>Hide. You may assign a password if desired

eparucki · Mar 6th, 2002, 09:19 AM

Hmmm.

That's exactly what I thought as well. However, the calculations do not seem to work for anyone else except for me -- with or without a password.

eparucki · Mar 6th, 2002, 09:45 AM

Eureka!

Figured it out... And it had nothing to do with actually protecting the data.

I was using MROUND and the users I was testing with did not have the Analysis Toolpak add-in installed.

Problem solved.

Thanks!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 07:55 AM	#1
eparucki New Member Join Date: Mar 2002 Posts: 3	I am currently trying to create a way to do the following: * have a user enter data on one worksheet * have that data manipulated in another spreadsheet (utilzing worksheets there, static data, formulas, etc...) * then have those calculations appear on the original spreadsheet The goal here is to not allow the users to see or manipulate the data/formulas in the second spreadsheet. I have all the data and the formulas done, but I cannot seem to achieve the goal of not having the users see the data/formulas. Any suggestions?? TIA!!

Mar 6th, 2002, 08:12 AM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Activate the sheet you don't want users to see and choose Format>Sheet>Hide. You may assign a password if desired

Mar 6th, 2002, 09:19 AM	#3
eparucki New Member Join Date: Mar 2002 Posts: 3	Hmmm. That's exactly what I thought as well. However, the calculations do not seem to work for anyone else except for me -- with or without a password.

Mar 6th, 2002, 09:45 AM	#4
eparucki New Member Join Date: Mar 2002 Posts: 3	Eureka! Figured it out... And it had nothing to do with actually protecting the data. I was using MROUND and the users I was testing with did not have the Analysis Toolpak add-in installed. Problem solved. Thanks!!