To Excel professionals?

Question

my work sheet has error in text cell .. it happens suddenly excel sheets stop working and i make an end task and open again i found all text cells has this word " #VALUE! " all links and all formulas is ok except the text cells ... what can i do to return my lost texts.

thanks

Answer 1

The reason why Excel, Word, Access etc are not in Add/Remove Programs because they are consider as modules in MS Office suite, to uninstall individual module, you have to put your MS office cd into the cd drive and there is a add/remove button, click that and then you can uncheck the specific module or its components then proceed with the rest of the procedure.

A few cases might cause #VALUE!

1. you put a range to a function that suppose to take single value e.g. =MATCH(D26:D28,D17:D19,0)  the D26:D28 should not be used as it is not single value like "a"

2. for some array formulas, before activation, it'll show #VALUE! e.g. {=VLOOKUP(D6:D14,D6:D14,1,FALSE)}  so ctrl+shift+enter right after entry is necessary

3. function expect a value that is not the same type as you supply, e.g. =POWER(2,"a")  the argument should be a number but text is used instead

since it come in a sudden, so i guess mostly is case 3, you have to examine the cell references in the formula to see if the type of value feed into the formula is the type that's expecting.

Hope this helps.