I have an ODBC query in Excel 2003. The query is in columns A, B, C and D. In column E, I am taking column C-D. However, when I refresh, and lets say the query (with parameters) returns 5 rows of data, the formula in column E is there. But when i put in a new parameter, and say it returns 10 rows of data, the formula (C-D) is lost. How do I get column E to keep that formula for however many rows of data??? Thanks!