VLOOKUP sections - SDL doesn't take into accounts these parts

Question

Hi all, 
 I've created a project for one of our clients including 1180 files. Some of them are in the Word format, others in the Excel one (docx and xlsx). In the Excel files there are some content that are not processed by Studio as they're vlookup sections, so it's like they're contain hyperlinks to external files. 
 Is there a way to tell Studio to include these sections in the reports? 
 Many thanks in advance for your help 
 below a screenshot (the yellow cell contain a vlookup section, see above space)

Paul Filkin · Accepted Answer

Gauthier Serkijn 
 Gauthier Serkijn said: Do you mean that If I translate those external Excel files, the formulae would be automatically updated in the final file? 
 Correct. That's the way Excel is supposed to work. 
 Gauthier Serkijn said: Do you think it would work anyway or could just the client see it? 
 If you have access to all the files as thery are linked then it will all work for you too. If not then it may only work for your client... which is the implrtant bit I think. 
 Gauthier Serkijn said: Otherwise, is there maybe another way to extract the data, i.e. the showed text regardless the formulae? 
 Only if you copy and replace the formulae with the text which is also possible. But this would probably be a foolish thing to do since you would break the structure of your clients file system. If they don't care then it would be fine, but I don't think you should do this without checking with your client first. Seems a fair discussion point if you want to deliver what's needed.

Paul Filkin · Answer

Gauthier Serkijn 
 
If this cell contains a formulae, which seems to be what you mean, then Studio will not extract this. You will translate the data the formulae refers to and that's how this cell will get updated when you open the file in Excel.

Trados Studio > 1. Trados Studio

VLOOKUP sections - SDL doesn't take into accounts these parts