Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

problems with sheet protection

Discussion in 'Information Technology' started by homeyworld, Jul 28, 2006.

  1. homeyworld

    homeyworld
    Expand Collapse
    Guest

    I've tried numerous times to lock the formula cells in my restaurant's daily
    sales & labor workbook. It has a sheet for each week of the month and a
    monthly summary sheet. The net sales and labor from the weekly sheets carry
    into the monthly summary sheet.

    I have locked the formula cells in the monthly summary sheet and protected
    the sheet, no problem. However, when trying to lock the formula cells in the
    weekly sheets, there are 2 cells that keep locking which I don't want to lock
    and am not selecting. The data in these cells do not carry into the monthly
    summary page.

    I have protected plenty of Excel workbooks/sheets before, and never had this
    problem.

    Any suggestions?
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Sikhs Face Problems While Carrying Kirpans In Khyber-Pakhtunkhwa - SikhSiyasat.Net Breaking News Jul 29, 2016
    "Dasam" Granth - A Look At The Core Problems Dasam Granth Oct 21, 2015
    Problems In Life Sikh Sikhi Sikhism Apr 13, 2015
    Muslim Girl-Sikh Boy Marriage Problems- Please Help! Love & Marriage Oct 12, 2012
    Problems with Sikh Historiography-prof Jagdish Singh Sikh Video Aug 31, 2012

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Wed, 12 Jul 2006 15:01:02 -0700, homeyworld
    <homeyworld@discussions.microsoft.com> wrote:

    >I've tried numerous times to lock the formula cells in my restaurant's daily
    >sales & labor workbook. It has a sheet for each week of the month and a
    >monthly summary sheet. The net sales and labor from the weekly sheets carry
    >into the monthly summary sheet.


    Please repost this Excel question in an Excel newsgroup. Scroll down
    the list of subject areas on the webpage and find a suitable Excel
    group; this is the first alphabetically, but it has to do with a
    different program, Microsoft Access.

    John W. Vinson[MVP]
     
  4. homeyworld

    homeyworld
    Expand Collapse
    Guest

    Duh! Thank you!

    "John Vinson" wrote:

    > On Wed, 12 Jul 2006 15:01:02 -0700, homeyworld
    > <homeyworld@discussions.microsoft.com> wrote:
    >
    > >I've tried numerous times to lock the formula cells in my restaurant's daily
    > >sales & labor workbook. It has a sheet for each week of the month and a
    > >monthly summary sheet. The net sales and labor from the weekly sheets carry
    > >into the monthly summary sheet.

    >
    > Please repost this Excel question in an Excel newsgroup. Scroll down
    > the list of subject areas on the webpage and find a suitable Excel
    > group; this is the first alphabetically, but it has to do with a
    > different program, Microsoft Access.
    >
    > John W. Vinson[MVP]
    >
     

Share This Page