Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: securing sensitive data/formulas

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!!


  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.


  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •