I have a table in Excel from an MS Query and I have formulas in adjacent columns referencing the table data. I want those formulas to fill down when the table is refreshed. This option was available in previous versions of Excel but I can't find it in 2010. Was this removed? Is there a way I can get this to work in Excel 2010?