ExcelBanter - Destination workbook formulae become #VALUE!

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Destination workbook formulae become #VALUE! (https://www.excelbanter.com/excel-discussion-misc-queries/121571-destination-workbook-formulae-become-value.html)

Peter Oz 67

Destination workbook formulae become #VALUE!

When I open my destination workbook, even if I select 'don't update', I am
finding all cells referring back to the source workbook become #VALUE!,
therefore wiping out the workbook until I actually open the source workbook.
This has only just started happening to me - this used to work OK.
Does anyone know how to fix this?

All times are GMT +1. The time now is 11:15 PM.