a formula that is linked to another workbook now returns an #VALUE! error
when the workbook is reopened.

When the workbook is reopened the formula shows the result but when
Automatic update of links is enabled the formula then produces the error.

No idea why this should happen.