Hi...

I have a fairly complex spreadsheet. Amazingly, formulas don't work unless I
enter the cell and press return and then the value shows. I can't do this for
every cell.

Why is this happening? and is there any code I could run in my auto_open to
prevent it happening? Auto calculation is fully enabled.

Thanks in advance