Results 1 to 5 of 5
  1. #1
    veterannz
    Guest

    Default Excel. Office xp formulae

    Can anyone tell me how to protect ONLY the formulaue in an excell workbook.
    I wish to be able to "clear contents" of any specific cell into which information has been entered incorrectly, but not to upset the formula contained within that cell. I cant see that it is covered in the tick box options available when protecting a worksheet

  2. #2
    Mike
    Guest

    Default Re: Excel. Office xp formulae

    If there is a formula contained within a cell, then there is no data contained within the cell, it'll be pulled from somewhere else. That means that if incorrect information has been entered, it would have to have been entered into another cell altogether.

    You can protect certain cells and leave others available for editing etc. if that's what you're wanting?

    Mike.

  3. #3
    veterannz
    Guest

    Default Re: Excel. Office xp formulae

    For example.
    D9 contains the formula =SUM('DPA etc totals'!R3:R242).
    if I were to enter the figure 6 into cell D9 accidently and then clear the contents to remove the error it would make the formula within that cell useless.
    I want to be able to edit cell D9 while still having the formula protected aginst change

  4. #4
    Mike
    Guest

    Default Re: Excel. Office xp formulae

    If there is a formula within a cell, and you enter a figure into that cell, then the formula is lost BEFORE you clear the contents to remove that error. As soon as you enter the number 6 into D9 you lose the formula. If there is a formula in the cell then it needs to pull its values from another cell. If you don't want to ever overwrite the formula, then you need to protect the contents of that cell (therefore you would not have been able to enter the value 6 into D9 to start with).

    Is that what you're wanting? If you're wanting to enter values into a cell containing a formula without losing the formula, I'm afraid it cannot be done.

    Mike.

  5. #5
    wotz
    Guest

    Default Re: Excel. Office xp formulae

    What you are looking for is on the protection tab of the format cells menu. Remove the tick from 'locked' box for any cells you want to be able to edit. In your case you might want to select all cells and do this, then put the tick back on for the cells you want to protect. Then protect the sheet fron the tools menu.

Similar Threads

  1. Excel 97, Office 97
    By tedheath in forum PressF1
    Replies: 4
    Last Post: 05-10-2003, 10:22 AM
  2. office 97 excel
    By dog4367 in forum PressF1
    Replies: 0
    Last Post: 30-04-2003, 06:58 PM
  3. Frontpage 2000 Use of formulae
    By in forum PressF1
    Replies: 1
    Last Post: 16-02-2002, 08:34 PM
  4. Excel in Office 97
    By in forum PressF1
    Replies: 0
    Last Post: 10-09-2001, 10:19 PM
  5. Replies: 0
    Last Post: 02-10-1998, 12:55 PM

Posting Permissions

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