Posts by Carbootgolf

    I have a wookbook (xl97) that is distributed to several different users. It allows them to input several pieces of information which in turn creates a text file.


    All areas are protected except for the input cells. however if someone uses the CUT function on an unprotected cell it messes up my text file.


    Is there any way to block some using CUT on an unprotected cell ?

    Quote

    Originally posted by Derk


    Select just the part of the formula you want calculated when you F9. This works in Excel 97, as does clickin on the = sign to the left of the formula Edit box.


    By hightlighting each cell ref gives me the answer i require (many thanks problem solved). But i have to agree that in XL97 selecting the = sign and pressing F9 still only shows the grand total.