When I use the New Web Query to import a table from a Coldfusion webpage to Excel 2007, I get the data from the table, but no formatting. I have verified that the 'Full Html formatting' is checked in the options box, and that 'preserve cell formatting' is checked in the properteries. There is a column of colors that I need to come over from the web page to excel. No formatting is coming over at all. I have tried this on mulitple computers and get the same problem. Does anyone know why this is happening?