I'm working on switching over from OLE to native tables from Excel datalinks. I want to preserve excel formatting (merged cells, column width, etc) but I want to override the font used. So far the only way I can see of doing it is to uncheck the option to use excel formatting. But if I do that the tables took dreadful! Has anyone every wanted to do the same or have any thoughts on things I could try?