I am writing a scientific report with lots of tables and figures in it. Most of them are linked to different excel files where they are managed separately. I am continuously updating the excel files as I get new results, so it works great for me this way.
BUT, whenever I open Word, it asks if I want to update the links. And sure thing, all the links are updated nicely, just like I want them to be. But all the captions disappear as well, and the cross references in the body text stop working as well.
Is there a way to keep the captions, but only update the actual table/figure?
Or maybe I am just doing it wrong to begin with?
