I need to protect formulas entered into cells which are summed up into a
subtotal row and grouped/outlined for presentation. As i apply the protect
worksheet, I can no longer expand or summarise presentation.

Does anyone have a solution as i do not want my formulas to be overriden and
need to be able to let users view both summarised and expanded results.

worksheet is as follows:

Expense Type Jan Feb Mar Apr

Marketing 200 250 200 300
promos 40 90 80 100
entertainment 60 60 70 50
advert 100 100 50 150

Office Expenses 300 300 300 300
stationery 100 100 100 100
photocopy 150 150 150 150
postage 50 50 50 50

Salary and Wages 600 650 650 600
Basic Salary 500 500 500 500
Overtime 50 100 100 50
travelling 50 50 50 50


The figures are calculated from a list on another sheet within the workbook
where data are usually entered without requiring any protection.