ExcelBanter - getting an error when updating links

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - getting an error when updating links (https://www.excelbanter.com/excel-worksheet-functions/247425-getting-error-when-updating-links.html)

Gotroots

getting an error when updating links

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.

All times are GMT +1. The time now is 03:36 PM.