My formula doesn't go all the way down on an ODBC query in Excel 2003

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!
brasimanAsked:
Who is Participating?
 
SteveConnect With a Mentor Commented:
IN 2003, I think (from memory here) you can right click inside the returned data and then in proerties select "fill formula down" (or something similar). This will maintain formulas next to the extracted data.
0
 
brasimanAuthor Commented:
I guess I am asking also how do i get the data to go into a table automatically? Also, how do i get my formula to follow my data? Again, this is Excel 2003.
0
 
brasimanAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.