1) I have a formulae in a cell but no corresponding value in £'s

M

Michael

I have a formulae as =Sum(H3:H6) in a cell which should display a value in
currency. No value is seen, but the grand total displayed at the end of the
sheet, including many other formulae ( shown in local currency ) includes the
missing items.

Also, how do you lock formulae without proctecting the whole sheet?
 
M

Marcelo

Hi, maybe your calculation is set as manual, go to
TOOLS|OPTIONS|CALCULATION|AUTOMATIC

Regarding to lock formulae, this is not possible, the way to do it is unlock
all cells of the spreadsheet, lock the formulas and protect it, so you just
have protected the formula ranges.

hope it helps
Regards from Brazil
Marcelo

"Michael" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Entry and Formulas 2
Adding numbers from sheet 2 to sheet 1 2
Formula structure 3
sum value of nonblank discontinuous cells 3
How can I stop a formula from executing based on a cell value? 4
saving values to cells 2
Date is not permanent 2
formula to look up and sum the Grand totals based on the Heading 4

Top