#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.

Please Login or Register  to view this content.