Goofy,

When EXCEL cannot calculate a valid value in a cell, it puts the text "#VALUE!" to indicate an error. This can be for a number of reasons, most likely an invalid value entered by you in some other sheet. Now I believe "VALORE" is Italian for "VALUE" - I'm guessing your language/culture is set to Italian.

The error in this cell may well be responsible for all the other errors further down (if they are somehow dependent on the value in this cell).

To give a very simple example:

If a cell, lets say A1 has the value "a", and the cell B1 has the formula "=A1*3".

Clearly you cannot multiply the letter "a" by 3 (at least in decimal math), so the "#VALUE!" error will result:

value error.JPG

So , you need to first click on that cell and examine it's formula, to work out what has gone wrong. This is almost certainly due to an error on your part (possibly an invalid entry in one of the sheets/cells referenced by this formula, such as entering text when it's expecting a number, etc...

If you do not identify the error from an initial examination of the formula, then you will need to trace this formula back to the cells from which it derives it's value, and then examine their values (or formulae, which may in term need to be traced back) until you discover the error.

CC

BTW. All this information is freely available in the HELP function (F1) that comes with EXCEL. Try searching for "#VALUE!" in the HELP.