Set documents of this kind shared / forwarded to others, to not update links. Upon opening, there is the question if wanting to update, to which you can then choose to say Yes / No on opening... Have many interlinked workbooks with this setting. It gives a chance to watch the key chart changes happen, but more importantly, allows running snapshot backups of the chart view data that 'was'. Some guidance: https://support.office.com/en-nz/art...b-edaa411a3847
or
https://support.office.com/en-za/art...e-4a84cff3a519