When I open up my spreadsheet I get a #NAME error in one of my cells, but if
I go to the formula and press enter it gives the answer!

Any ideas why it does this? - I want to hide this cell, so don't like the
manual workaround!

Thx