HI,
This is very small issue i will help you in this regard if your are happy with my solution you can pay me or a small review that will help me .
1) Open the files separately i.e German, UK, and France, in that go to "Data" Tab in the blue Ribbon and there you will find Tab " Edit Links" just Below the "Data" tab click on that then click " Break Link" will be on right side of dialogue box popped up by doing this all the linked data in the respective sheets will be saved "Values" no more links
In case of more assistance fell free to ping me i will help
With Regards,
Raman