|Excel will allow me to insert function in a cell and reports thro dialogue the result. The cell displays the formula in a text form but no result. Copying cell contents is just that. No updating of cell refs.|
This is not consistent as columns a to q do calculate formulae, but col r will not!
Is there a setting I have accidentally changed or is this a bug?