M
mlv
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
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