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

Posted on 2013-06-05
Medium Priority
Last Modified: 2013-06-07
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!
Question by:brasiman
  • 2

Author Comment

ID: 39222872
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.
LVL 24

Accepted Solution

Steve earned 2000 total points
ID: 39223693
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.

Author Closing Comment

ID: 39229446

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question