DDE Links connection lost after saving

Hi All,
I’m using Writer to make a kind of for sales pitch I send to my clients where I include my price list using DDE links from a Calc file.
The cells in Writer were automatically updating if I made a change in the Calc file. However, it only worked until I save and close the document. When I reopen the Writer document or making a copy of it, the cells are not updating anymore. I didn’t move or copy my Calc file, so the external links path should be the same.
How can I keep the DDE Links active even after save and close or editing a copy of that document?

Thank you for your helps

Info of my LibreOffice version
Version: 7.5.3.2 (X86_64)
Build ID: 50(Build:2)
CPU threads: 12; OS: Linux 6.3; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded