+ Reply to Thread
Results 1 to 4 of 4

Protecting Formulas

  1. #1
    Registered User
    Join Date
    03-15-2017
    Location
    Illinois
    MS-Off Ver
    2013
    Posts
    2

    Protecting Formulas

    I am creating a spreadsheet for reporting numbers (statistics) with each branch reporting in a separate tab and to tab showing the totals. To better protect the process of reporting and avoid accidental deletion of formulas, I have a couple of questions:

    1. Can I protect the specific cells, that contain formulas, while allowing the user access to adding the numbers/values that are to be added on a monthly basis?

    2. Can I restrict who can enter numbers/values to which tabs/sheets? These will be different individuals for each tab.

    3. Can I, on top of these other restrictions/protections, add a separate password for the file itself?

    Thanks.

  2. #2
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    01-31-2013
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    1,073

    Re: Protecting Formulas

    Hi -

    I think you can do those things.

    You go to the REVIEW tab and look at the Protect Sheet and Protect Workbook options. Also, there is an option where you can allow specific users to Edit specific ranges (the "Allow Users to Edit Ranges" item). I don't use this a lot, but I have used some of it on occasion. I takes a little fiddling around to get what you want, but it seems to work.

    Hope this helps.
    ____________________________________________
    If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
    -Go to the top of the first post
    -Select Thread Tools
    -Select Mark thread as Solved

    If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.

  3. #3
    Registered User
    Join Date
    06-04-2014
    Location
    USA
    MS-Off Ver
    Office 2016
    Posts
    72

    Re: Protecting Formulas

    Under the Review tab in Excel you will see a couple options; "Protect Sheet", "Protect Workbook" and "Allow Users to Edit Ranges" which I believe will cover all three needs.

  4. #4
    Registered User
    Join Date
    03-15-2017
    Location
    Illinois
    MS-Off Ver
    2013
    Posts
    2

    Re: Protecting Formulas

    Thank you - I have not previously used these functions and am therefore not familiar with the terminology (I saw there were many options for protecting cells).
    Again, thank you so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 9
    Last Post: 12-04-2015, 05:19 PM
  2. Protecting Formulas:theoretically the formulas
    By Shandsboy in forum Excel General
    Replies: 4
    Last Post: 08-10-2009, 11:57 AM
  3. Protecting formulas
    By val2009 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-24-2008, 01:20 AM
  4. [SOLVED] Protecting my formulas
    By marko in forum Excel General
    Replies: 2
    Last Post: 12-19-2005, 02:45 PM
  5. Protecting my formulas
    By marko in forum Excel General
    Replies: 2
    Last Post: 12-19-2005, 02:45 PM
  6. [SOLVED] Protecting Formulas
    By brose in forum Excel General
    Replies: 6
    Last Post: 04-28-2005, 09:06 PM
  7. [SOLVED] Protecting formulas
    By EllenSwarts in forum Excel General
    Replies: 2
    Last Post: 03-04-2005, 07:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1