Excel Rejects Formula (Shaded Cells)

[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

 

[Earl Kiosterud]

Mike,

This sounds like Data - Validation.

--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting. But if you bottom-post to a reply that's already
top-posted, the thread gets messy. When in Rome.

 

[Guest]

This can only be done with Data Validation or VBA....
So select the cells, then go to Data---> Validation

Check to see if there is a set validation.
If not, go to Tools----> Macros -----> Play Macros

Then click on the macros and click edit, and look at them to see what they
are doing. Let me know if this works.

 

[mlv]

This can only be done with Data Validation or VBA....
So select the cells, then go to Data---> Validation

Check to see if there is a set validation.
If not, go to Tools----> Macros -----> Play Macros

Then click on the macros and click edit, and look at
them to see what they are doing.

Let me know if this works.

Thanks to you and Earl for your help.

There was a Data Validation set that was causing the problem.