#NAME errors

I have looked throughout the web, including this site, for an answer to this question but I can't find it.

I have a very complex book that uses named cells as well as vba functions, and also iterative calculations. It works splendidly so long as I don't save it then reload it.

If I do that, then it comes back with #name errors.

If I turn off automatic calculations then there are no #name errors on loading, and then I can turn automatic calculations back on and everything is fine.

So I thought about the following workbook macros, but they don't work. Maybe this is the wrong approach, anyway. Does anyone have any ideas? Thanks.

Private Sub Workbook_Open()
    Application.Calculation = xlCalculationManual
    Application.OnTime Now + TimeValue("00:00:01"), "StartCalculator"
End Sub

Public Sub StartCalculator()
    Application.Calculation = xlCalculationAutomatic
End Sub