+ Reply to Thread
Results 1 to 2 of 2

Locking a sum formula while still allowing users to insert and delete rows

  1. #1
    Registered User
    Join Date
    02-16-2015
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    6

    Locking a sum formula while still allowing users to insert and delete rows

    Im in a pickle.

    At my work we use spreadsheets split into weeks. Each weeks data is summed in a formula. What we are having issues with is users deleting the sum formulas accidentally and not realising it. To solve this we have added in a row above the sum formula and the top most row the formula takes into account and greyed them to make them stand out. We then lock these 2 new rows aswell as the sum formula. My issue is we have to allow the users to insert and delete rows as the data can grow and shrink from week to week and month to month. This poses a problem because other than accidentally deleting formulas my staff now tend to add their extra lines they need below the grey and above the sum formula which breaks the sum formula so it is no longer anchored.

    Is there a way i can make it impossible for my staff to insert and delete rows inbetween the grey line and sum formula for each week.

    I am unable to use macros in this situation as the company is not a fan.

    FINGERS CROSSED

    EXAMPLE.xlsx

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Locking a sum formula while still allowing users to insert and delete rows

    It's probably best if you upload a workbook that does not have password protected cells.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

+ 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. [SOLVED] Allowing Users to Input Data into Cells Containing Formulas without Deleting the Formula
    By MayBTheresHope in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 10-29-2018, 07:43 PM
  2. Replies: 2
    Last Post: 04-05-2014, 03:45 PM
  3. Replies: 1
    Last Post: 11-21-2013, 02:51 PM
  4. Protect Sheet Allowing Users to Format Rows/Edit Objects?
    By Kristine T. in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-16-2009, 04:38 PM
  5. Excel 2007 : Locking Sheet But Allowing users to group
    By AlexApazidis in forum Excel General
    Replies: 0
    Last Post: 02-19-2009, 03:06 PM

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