It appears that Excel reimport does seems to work anymore. Changes made in Excel are not reimported although the changes have been saved and I have checked the CaveRenderPro.xls... changes are actually there.
I had a similar issue where after reimport from a txt file the changes that I made had been imported to a different cave. So it looked like the import didnt work but the data was actually just at a different cave that I didnt check at first. When looking at the txt file after export I noticed that the fields for 'Höhle' already had incorrect values, which means the issue stems from a bug in the export process.
I also had cases where part of the data in my txt file was from one cave and another part was from another cave, even though I had only exported a single cave. After reimport each batch of data was imported to its respective cave. This led to a cave getting duplicate data without me noticing at first. I can not reproduce these issues at the moment.
Another potential source for Thomas issue could be this: If my CRP project file has multiple caves where the field 'Höhlendaten - Höhle' is not filled out, the reimport will always happen at the first cave in the list that also does not have 'Höhlendaten - Höhle' filled out.
Thanks for your inputs! I found the issue: the file had 2 caves with same ID... . Problem solved with paste issue as well. To avoid this to happen, maybe there should be a test on cave ID uniqueness when entering or editing the cave ID.