Solved

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

Posted on 2013-06-05
3
194 Views
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!
0
Comment
Question by:brasiman
  • 2
3 Comments
 

Author Comment

by:brasiman
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.
0
 
LVL 24

Accepted Solution

by:
Steve earned 500 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.
0
 

Author Closing Comment

by:brasiman
ID: 39229446
Thanks!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

911 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now