Hi Gang,
Pulling my hair out over this one! I’m trying to import an XLS spreadsheet into ID as a link, and apply formatting automatically at the same time. My problem is an odd one – the XLS that I’m importing contains linked cells which are imported as values (ie. the content shows up correctly) when I import the XLS as unformatted. When I try to import the XLS as formatted, ID decides to ignore the cell values of the XLS (return a zero) in each linked cell.
Can anyone advise please? It’s driving me mad!
Best, Simon