Hi

I have taken an existing Excel 2002 Invoice and used it as a starting point
to create new invoice.

Everything seems to work fine, except in the totals column I cannot enter
any formulae.

I am trying to use the following formula :

 =IF(B26<>"",B26*I26,"")

Basically, if there is a value in cell B26, then cell B26 is multiplied by
cell I26 to give the product.

The problem is I get the following error message when I try to enter the
formula:

 "The shaded cells contain formulas and are automatically calculated by
Excel.  DO NOT enter any information into them."

There are no 'shaded cells' anywhere on the invoice sheet that I can see and
I have tried selecting all the affected cells, right-clicking and selecting
'clear contents'.  In fact, I've tried everything I can think of to clear
these cells, but I still can't enter any formula.

I guess  the problem is a legacy from the invoice I used as a template
(which I think also ran an associated Visual Basic macro file).

Can anyone advise a way to resolve this problem?

Thanks