I am trying to use Datalinks to import some excel tables. Everything is working fine except for two issues:
1- I am having trouble controlling the text height within Excel. I know this can be changed in the table properties once the datalink has been inserted, but I would rather control the text height in Excel. For example 10pt font ends up being .1388, but when I import the Datalink, I get .0972
2- Text Style. Is there a way to use a shape font? Or any other font than the font used in Excel while maintaining the datalink?