Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 246
  • Last Modified:

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!
0
brasiman
Asked:
brasiman
  • 2
1 Solution
 
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
 
SteveCommented:
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:
Thanks!
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now